| Groups | Blog | Home |
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Using variable in SELECT statement Posted by Shas at 8/31/2005 11:19:15 AM I'm pretty new to asp but have coded before (many years ago) and
understand databases. I am trying to use a variable in a SELECT
statement, which I have done elsewhere in the same script, but can't
get this particular bit to work.
I'm retrieving a property record and then picking up a photo fo...more >>
select statement for in inclusion list Posted by TB at 8/31/2005 12:00:00 AM Hi All:
Here is a question for you SQL gurus:
I have a table called "accountmovements' registering movements on member
accounts with the following columns (type):
ID (integer) - Primary key
Accountholder (integer)
Datemovement (date)
Amount (decimal)
Text (varchar)
I would like cre...more >>
ASP to EXCEL Posted by DNKMCA at 8/31/2005 12:00:00 AM Hi,
Im creating an Excel file using ASP
Versions : Office 97
The formattting is not working properly in Excel 97, but the same works fine
in Office XP & 2000
Is there any additional code has to be added in my code to get a formatted
output in Excel 97 version?
Please help.
Thanks.
...more >>
ASP Error after Server migration Posted by ...Adam at 8/29/2005 10:16:21 AM I have an ASP site that uses an Access Database. There is one page that
each site uses to input their data (numbers) and that info gets put into the
database. This part works.
Then, on the same page, it will display the numbers that were inputed within
each category - This doesn't work.
...more >>
Import comma delimited file Posted by Elmo Watson at 8/28/2005 4:06:17 PM I've been asked to develop an automated type situation where we have a
database table (sql server) and periodically, there will be a comma
delimited file from which we need to import the data, replacing the old.
I naurally know that we can use [truncate tablename] to kill the other data,
but d...more >>
Error while executing a sql statement via connection string. Posted by Jack at 8/22/2005 7:23:01 AM Hi,
I am testing an application designed by a contracting party. While testing a
page
I am receiving the following error:
Error Type:
Microsoft JET Database Engine (0x80040E57)
The field is too small to accept the amount of data you attempted to add.
Try inserting or pasting less data.
/...more >>
Date - Time Format Posted by Doug at 8/19/2005 9:58:47 PM I am using ASP to access a database and pull out the date in the database
that is in this format: 7/5/2005 9:20:22 AM
I want to make it display on the page in this format which is a standard
miltary DTG(Date/Time/Group) format and in Zulu (GMT - Grenwich Mean Time).
For example this would be...more >>
Get data type of column Posted by Mike at 8/17/2005 12:00:00 AM How do I get a textual description of the data type of a SQL Server table
column?
(Returned to ASP preferably)
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Solution for Unspecified Error on Windows 2000 using Jet Posted by johnner at 8/16/2005 12:00:47 PM Hi There,
I just wanted to post this solution that we found to the common
"Unspecified Error" on Windows 2000 server.
when trying to access a database from ASP pages using the ODBC JEt
driver. For those of you that have tried all the other recommend fixes
such as checking the IUSER_ permi...more >>
Repeated Region Insert Posted by nathan at 8/16/2005 7:43:47 AM Ok, for the past two days, I've looked at every tutorial/post I could
find regarding this, and to be honest I'm losing my mind.
What I have is a form, with a repeated region in it, in this repeated
region, are text boxes populated from a recordset (and some are
populated from url variables). W...more >>
access - recordset - sometimes endless loop, sometimes not Posted by MiniMike at 8/16/2005 12:17:02 AM I'm having this very weird problem on my website. I'm using ASP, and an
Access 2003 database.
The problem is this:
When i surf to my page, there's usually no problem.
I have this select statement :
SQL = "Select * " _
& "from tblTable " _
& "order by intID desc"
Set RS = Conn.Execut...more >>
Can't connect to an access database Posted by jj at 8/15/2005 12:00:00 AM Hi all
I am trying to connect to an access database with the following code:
<html>
<title>Formular</title>
<head>
</head>
<body>
<%
' Databaseforbindelse - husk at angive sti til din database
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (...more >>
Scheduling application - detecting conflicts? Posted by Jake at 8/13/2005 1:33:12 PM Hi guys!
I have a scheduling application which allows the user to reserve timeslots
for various things but Im having trouble figuring out how to detect if a
reservation being added is conflicting with an existing reservation.
Basically its a logic problem.
I am currently able to detect tim...more >>
SQL Database Questions Posted by Jonathan at 8/12/2005 1:07:01 PM I am looking to replace an Access database on my web site with an SQL
database. I am running IIS to host the web site and I have a few basic
questions:
1) How do I create the database file? Do I need some kind of editor like the
Access program?
2) What connection string do I use?
3) Do ...more >>
Serving Up Files Through a Firewall Posted by paul.schiele NO[at]SPAM procura-inc.com at 8/11/2005 1:57:03 PM I have read several posts on the merits of storing the path to a file
in a database versus the storing the image in a database. How are
people accomplishing this if the disk storage is on the internal
network and the web server is on the other side of the firewall? If
you store just the link t...more >>
ASP Login and statistics Posted by Marina Limeira at 8/10/2005 9:07:27 AM
I want to create a site with some pages and necessary to create accounts of
users for Login in the site and with time determined for expire of logon.
would like to know when each user and
pages visited, (statistics per user)
Also ideas?
Thanks,
Marina
...more >>
Perform functions on recordset? Posted by Mika at 8/8/2005 8:16:05 AM Is it possible to perform functions on a recordset (rather than on the
source database), e.g. COUNT, MAX etc
The reason I would like to do this is because I have a hugely complex view
which produces results with over 60 columns of data. I would like to display
all data but also highlight in...more >>
Query on Access Database Posted by Matt Simms at 8/8/2005 7:53:07 AM Dear All,
Let me explain my code problem:
I have a calls table consisting of:
callno, ID, callbackdate
A Contact table consisting of:
ID (link between calls and contact),clientname,status,contactname,renewaldate
Data in table is Contact:
18,Nick Hunt,Saffrons Bistro,E,'null'
...more >>
Inlcude Null Values in Result Set Posted by Adrienne at 8/7/2005 8:26:46 AM ***
Sorry if this message came twice, I wanted to cross post, and sent it
before doing so. I tried to cancel the original.
***
I'm working with an Access DB, and two tables. This is going to be
ported to MS SQL shortly. The tables are category and merchantcategory,
and the link is on c...more >>
display access error message on asp page Posted by iam247 NO[at]SPAM gmail.com at 8/7/2005 7:02:46 AM Hi
I am working an a prototype asp acess2002 database. Currently I have
not set up a page to check if a new users email address is already
present on the DB. I have set access to not allow dulicates on the
emailAddress field.
Obviously when someone attempts to register an email address for ...more >>
Include Null Values in Result Set Posted by Adrienne at 8/6/2005 9:41:25 PM I'm working with an Access DB, and two tables. This is going to be
ported to MS SQL shortly. The tables are category and merchantcategory,
and the link is on category.id and merchantcategory.category_id.
*** Category Table ***
id, category
1, apples
2, oranges
3, lemons
*** Merchantca...more >>
ASP, Access and time problem Posted by Terry Murray at 8/5/2005 9:00:59 PM Hi everyone. I am having problems trying insert a time value into an Access
table. The field in the Access table is of the the type Date/Time.
My code follows:
<%
dy = Day(request.form("date"))
mnth= Month(request.form("date"))
yr = Year(request.form("date"))
mydate= "#" & yr...more >>
Question about login script Posted by Joe at 8/4/2005 5:24:04 PM Hi,
I have a login page. Where user enters an email and password. Then I;m
checking if user account is active or not. Before a user can login, he needs
to activate his account. If the account is active then Active field is set
to yes (1) otherwise to no (0).
If the user’s account is...more >>
Cannot open SQL Server from ASP page Posted by m.fisher NO[at]SPAM uku.co.uk at 8/4/2005 12:45:20 PM Hi
I have an asp page running on my Windows XP Pro PC at home. I have a
virtual directory setup in iis. ASP files run ok, but I am trying to
access a remote SQL Server database hosted by an ISP. The message I
get is:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][Conne...more >>
Help with sql syntax in asp Posted by iam247 NO[at]SPAM gmail.com at 8/4/2005 6:10:35 AM Hi
I really struggle with SQL syntax when using VBscript asp.
The following statement works OK:
strSQL = "SELECT qryGroupContactDetails.* FROM qryGroupContactDetails
WHERE GroupName = '" & Request.Form("GroupName") &"' "
This was copied and modified from someone else's sql
Group name...more >>
ASP Access and date problems Posted by polilop at 8/3/2005 7:49:02 PM this is wierd. I have a field in my access db that is short date
(dd.mm.yyyy).
In the Query i have to write it out like this #dd/mm/yyyy#.
Done that OK
But now if the 'day' part of the day is two digit like 28.07.2005
works fine.
But if the 'day' part is one digit like 08.07.2005
it think...more >>
Database design Posted by BaWork at 8/3/2005 5:47:37 PM I'm working on a database for a web app and I'm stuck. What is better in
the long run and what are the pros/cons of each design
Version 1
4 tables: Organization, Season, League and Team
Season is related to Organization, League is related to Season and Team
is related to League.
Orga...more >>
identical field names in 2 different tables Posted by steve at 8/3/2005 4:14:36 AM I am carrying out an INNER JOIN on 2 tables which share some common
field names.
When it comes to displaying the data in the recordset, how can I
distinguish between the fields? i.e. how I can I specify which
particular field I want to be displayed.
I tried syntax such as:
response.write...more >>
Need help understanding regular expression Posted by Joe at 8/2/2005 4:26:45 PM Hi,
I have been using a regular expression that I don’t uite understand to
filter the valid email address. My regular expression is as follows:
<asp:RegularExpressionValidator id="valValidEmail"
runat="server"
ControlToValidate="txtEmail"
Validat...more >>
Paging, Subsort Recordset Posted by Kevin at 8/1/2005 10:15:56 PM Can anyone point me to a code example where a recordset.absolutepage is =
sorted independantly of the original recordset. That is; if I populate =
an ADO recordset with an ORDER BY ListingDate clause, and I need to =
(subsort) recordset.absolutepage five of my paging on another field, say =
for...more >>
If array is empty or null response.write "...." Help please Posted by iam247 NO[at]SPAM gmail.com at 8/1/2005 9:52:26 AM Hi
Firstly thanks to the number of people who have helped me with this
project over the past week.
Apologies in advance if I use ht eincorrect terms.
I have an array named rsGoupsP which is populated by a SQL statement -
it works fine and is later used to populate a drop down list in a fo...more >>
Syntax error in the SQL Posted by Phillip Windell at 8/1/2005 9:42:30 AM Hi folks,
I get a error stating that there is a syntax error in my SQL Statement. I'm
not seeing what it is, but maybe someone else will.
Exact error from the browser page is:
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error in UPDATE statement.
/pilots/SubmitEvent.as...more >>
receive e-mails Posted by jamal at 8/1/2005 12:00:00 AM hi guys I am looking for a way to read & download my e-mails from my pop3
account from another server by using ASP(vb)
If you know anything about this subject please feel free to let me know.
I learn how send but not receive.
thanks
Jamal
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |