Webmaster Forum / ASP / Database Access / August 2006

I create a content management system using SQL Server and ASP that uses 2
tables, content and categories.  Structure listed below:
content
contentID identity int

i create sql function like this:
function select_snif (snif )
    if  snif <> ""  then SQLstr = "SELECT * FROM SWITCH where snif like '" &
snif & "'order by snif,id  "

I'm trying to export a recordset from a webpage to excel, however, only
part of the recordset does not populate in the excel file.  The entire
recordset will populate if I have it write to a web page.  I'm using
the following script to initiate the export:

I'm trying to loop through a response form, read the value of a given
response....then later write it to a database.
I am having problems with the following code...and am thinking that I have a
problem with the syntax of reading the form response.

Please help!  I've been scouring the newsgroups and been through
Microsoft's troubleshooting page, but can't find anything to fix this,
so far.  It sounds like a lot of people have been having a similar
problem, though.

I am experienced in Access, but new to ASP....
I have an online survey that I want to add results to an access table...by
using a saved query with paramaters...
Not sure where my code is failing....or for that matter what the best way to

Howdy all.
2 questions related to dates.
Thanks in advance,
Rey

I can't seem to get id of new record.  What am I missing ?
strCon = "Provider=Microsoft.Jet.OLEDB.4.0;"&_
 "Data Source=" & Server.MapPath("/mydb.mdb")
set conn=server.createobject("adodb.connection")

I run an ASP script that invokes a stored procedure which creates a table,
next step in that same ASP page there's a select statement that loads data
from that recent table. That data is loaded into a recordset.
Problem is that some of the values printed to the page that are ...

Heya guys,
I want to pack up a few of the tables in my database to send to a
developer to develop aspx code.  I was thinking it would be great to
create a .bak file with just those tables he needs to do the

when I tring to set date (oracle)  through my asp page
the year value get corrupted the date format I am using is 'dd/mm/yyyy'
2006 become 0006
2005 become 0005

hi, i am trying to update a recordset in access using a variable
for example
varStore = "4th Avenue Store" or it could be "10st Street Store"
my recordset is rstStore

Hi: Is it possible i call access form in browser.
Thanks,

Anybody have any experience with plotting map points with Google Maps
API from an Access DB?
I have a database with about 90 locations that I would like positioned
in the Google Maps.  I found a cool tool to get the long and latitudes

Dear Engineers.....Help!!
Every time I try to execute with IE an .asp page that has the following
code:
<%