all groups > inetserver asp db > june 2004 > threads for june 29 - 30, 2004
Filter by week: 1 2 3 4 5
Absolute Products the Best for ASP!
Posted by DavidM at 6/30/2004 10:11:54 PM
Hello all -- I recently stumbled across a great company with wonderful
products for easy integration within ASP pages. I've even created a
community forum to support the products on my site. Please feel free to
visit.
http://www.micro-mess.com/forum/index.php?c=9
http://www.xigla.com
T... more >>
Exception error querying Access database from ASP page... Memo field type?
Posted by Noozer at 6/30/2004 7:51:28 PM
Hi!
Working with an MS Access database from an ASP webpage and I'm getting an
Exception error...
Error Type:
(0x80020009)
Exception occurred.
/Projects/App/Mypage.asp, line 184
The SQL statement looks like so...
strSQL = "SELECT Cat, MyNote FROM Notes WHERE KeyLink = " & SelKey
rsS... more >>
Problems connecting to Access through FP
Posted by Wayne Smith at 6/30/2004 7:19:10 PM
Applies to: Microsoft Front Page 2000, Microsoft Access 2000
Operating System: Windows 2000 Professional
Web Server: IIS 5.0
I've created a very basic registration page called register.asp which =
consists of a form requesting a username & password, I then used the =
database wizard within FP... more >>
Help needed with ASP form browse for file, create link to file and insert in access database
Posted by googlenews.30.jondodds NO[at]SPAM spamgourmet.com at 6/30/2004 9:44:05 AM
I have a form where a user enters their name, date etc.
i also want them to be able to click on a browse button and select a
file which will then appear in a textbox. when they press submit i
want the file name and path to be put into the database. e.g.
"C:\windows\work\work.doc". Basically I d... more >>
MS Access SQL: duplicate record... ?SELECT INTO....?
Posted by Scotter at 6/29/2004 11:41:20 PM
What syntax would you use to dupe a record?
Thanks!
--
Scotter
... more >>
Unwanted Rounding
Posted by Jeff at 6/29/2004 6:57:17 PM
I have a decimal datatype set to precision 5 and scale 2. When I try to
insert a new record via ASP using a stored procedure, my numbers are rounded
with no decimals (e.g., 2.2 becomes 2, 2.6 becomes 3, etc.). How can I make
sure the values being entered on my web page are inserted as they are
... more >>
VB code is too fast => gives wrong value
Posted by Andre at 6/29/2004 4:45:12 PM
Hi,
I need to fetch a value in an Access db, so i use a form to pass the
parameter for the SQL statement fromVB client to ASP. After the submit line
in VBscript, i expect the value in order to test it and go further in
VBscript. But my problem is when clicking on the button, that the VB code
... more >>
OPENROWSET() fails 'Ad Hoc Access..denied' ADO
Posted by K. Lobe at 6/29/2004 2:16:29 PM
I'm tring the the following where strDBtoOpen is the UNC path to an Access
Database:
..ASP page ADO Connection object Source property.
cn.Source = "SELECT DD.* FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','" &
strDBtoOpen & "';'admin';'', DueDiligence) as DD WHERE ReviewedBy IS NOT
NULL"
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Caching RecordSet
Posted by Serge Myrand at 6/29/2004 9:59:02 AM
Hi,
I need an input! I am working on an ASP web application that allow
customers to order products from the web site. The products pages show
only 20 products at a time, I would like to avoid to requery the table
every time the user to navigate between pages (I do not know big the
table could... more >>
ASP/Access2002: how do I get column names from table (in order) using OLE DB?
Posted by Scotter at 6/29/2004 3:52:10 AM
When I use ADOX to get columns(fields) of a table, they are auto-sorted
alphabetically by name.
I need to get the list of field names as they appear when I open the MDB
file and view details of the table.
I tried using open schema with following code causing this error msg: "Item
cannot be foun... more >>
ASP/Access 2002: how do I get column names from table (in order) using OLE DB?
Posted by Scotter at 6/29/2004 3:50:16 AM
When I use ADOX to get columns(fields) of a table, they are *auto-sorted
alphabetically by name*.
I need to get the list of field names as they appear when I open the MDB
file and view details of the table, *not* sorted by field name
alphabetically.
I tried using open schema with following code... more >>
|