all groups > inetserver asp db > october 2004 > threads for october 15 - 21, 2004
Filter by week: 1 2 3 4 5
How to create connection pool in asp??
Posted by Utada P.W. SIU at 10/20/2004 2:16:41 PM
Thanks a look~
... more >>
results page not filtering on date
Posted by Raymond Keattch at 10/19/2004 2:58:17 PM
Microsoft Access backend database.
I am trying to filter a recordeset on several criteria, including dates.
The page works but the data is never filtered on date. Here is the code
in the results page
strWhere="WHERE"
strOrderBy = " ORDER BY"
if (request.form("chkSorting")="date") then
... more >>
viewing contents of field type "long text"
Posted by Paul Thakur at 10/18/2004 8:00:30 PM
I am writing vbscript code in an .asp page. I need to display field values
from a sql table consisting of several fields, one of them is of type "Long
Text". This field contains XML data. I like to be able to assign vale of
this field to a variable, display it and write out a text file using file... more >>
viewing contents of field tyep "Long Text"
Posted by Paul Thakur at 10/18/2004 7:57:32 PM
I am writing vbscript code in an .asp page. I need to display field values
from a sql table consisting of several fields, one of them is of type "Long
Text". This field contains XML data. I like to be able to assign vale of
this field to a variable, display it and write out a text file using file... more >>
ASP to DB to FDF to PDF
Posted by H8ids at 10/18/2004 3:48:51 PM
Working on an online submission form which needs the ability to print the
submitted information from a PDF document. The document has to be generated
on the fly and have the option of opening or saving.
Can this be achieved with ASP and Microsoft Access?
... more >>
network drive and MSWC.nextlink
Posted by Kanan at 10/18/2004 11:55:02 AM
hi,
Is it possible to access a file from network drive in ASP? Second question is,
How is it possible to use GetNthURL to access this file in the network drive?
I would appreciate if somebody has any example on using this feature.
thanks
Kanan... more >>
database connections in ASP
Posted by evandelagrammaticas NO[at]SPAM hotmail.com at 10/18/2004 6:25:25 AM
Hi guys... I am developing an application and need some advice while
the application is still in its infancy.
1. Set Conn = Server.CreateObject("ADODB.Connection")
2. Conn = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" &
Server.MapPath("documents.mdb")
3. Set rs = Server.CreateObject("ADOD... more >>
SQL Error - not retrieving any record
Posted by westernnord NO[at]SPAM webtv.net at 10/17/2004 5:37:30 PM
I am getting the following error:
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.
/sds-test/admin.asp
Here is the code:
sqlString = "SELECT current_weekday, " &_
"current_open_time, ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Stored Procedure & Quotes!
Posted by Anthony Judd at 10/17/2004 10:57:26 AM
I have a log in stored procedure. If some one was to enter a word containing
an apostrophe, i understandably get an error.
So i did the typical replace one quote with two. With standard sql
statements this often is the remedy.
In this case however i am still getting a syntax error. How do i deal... more >>
Sports DB
Posted by Whodat at 10/15/2004 6:48:13 PM
am new to dynamic web design and am having some trouble designing a db/web
form for a hockey team. I am hoping to have a form that will update the
records for each player on the team.
I have created a table in my DB with the following column headers:
playerid (primary, autonumber)
playernam... more >>
Form: extract VALUE and DISPLAY value?
Posted by jason NO[at]SPAM catamaranco.com at 10/15/2004 3:29:55 PM
What is the best way to extract incoming ID form variables and their
corresponding text values.
Is there an easy way to extract both the initialized value on the form and
its DISPLAY value.
For instance my form element may look this:
<input type=text name="StateID" value=<%=StateID%>>Flor... more >>
|