sql script won't run asp page

[Supaya]

Hi,

I'm developing a site with a public and members section. I'm using
vbscript, asp, and an access database. The login page is processed by
the members page. If you are a valid member the member page loads.
If not the member page redirects you to the restricted access page.

On the restricted access page I want to run a script that records
information about the user trying to login. I'm using environment
variables for this. The data is captured fine but my sql query isn't
working. I can't see any restricted words in there and I don't know
why the script won't run....any help would be appreciated.

script:

sql = "insert into tblfailedlog accessdate = '" & now() & "',
path_info = '" & request.servervariables("path_info") & "',
remote_addr = '" & request.servervariables("remote_addr") & "',
remote_host = '" & request.servervariables("remote_host") & "',
request_method = '" & request.servervariables("request_method") & "',
script_name = '" & request.servervariables("script_name") & "',
server_port = " & request.servervariables("server_port") & ",
server_port_secure = " & request.servervariables("server_port_secure")
& ", server_protocol = '" & request.servervariables("server_protocol")
& "', http_accept_language = '" &
request.servervariables("http_accept_language") & "', http_host = '" &
request.servervariables("http_host") & "', http_referer = '" &
request.servervariables("http_referer") & "', http_user_agent = '" &
request.servervariables("http_user_agent") & "';"

set rs = conn.execute(sql)

even when I change the sql statement to:
sql = "insert into tbltest testdata = '" & testdata & "';"
doesn't work either.

All my other pages are working fine - inserting, updating, deleting,
and selecting.

any help would be greatly appreciated.

Thanx

[Raymond D'Anjou \(raydan\)]

Just before:

> set rs = conn.execute(sql)

add:
response.write sql
response.end

Run the page to see your SQL statement.
Try to spot the error in the string.
If you can't see anything there,
copy the string and run it directly in your database.

"Supaya" <tonyabishop@hcse.ca> wrote in message
news:eaf17c37.0404010807.4f02331a@posting.google.c om...

> Hi,
>
> I'm developing a site with a public and members section. I'm using
> vbscript, asp, and an access database. The login page is processed by
> the members page. If you are a valid member the member page loads.
> If not the member page redirects you to the restricted access page.
>
> On the restricted access page I want to run a script that records
> information about the user trying to login. I'm using environment
> variables for this. The data is captured fine but my sql query isn't
> working. I can't see any restricted words in there and I don't know
> why the script won't run....any help would be appreciated.
>
> script:
>
> sql = "insert into tblfailedlog accessdate = '" & now() & "',
> path_info = '" & request.servervariables("path_info") & "',
> remote_addr = '" & request.servervariables("remote_addr") & "',
> remote_host = '" & request.servervariables("remote_host") & "',
> request_method = '" & request.servervariables("request_method") & "',
> script_name = '" & request.servervariables("script_name") & "',
> server_port = " & request.servervariables("server_port") & ",
> server_port_secure = " & request.servervariables("server_port_secure")
> & ", server_protocol = '" & request.servervariables("server_protocol")
> & "', http_accept_language = '" &
> request.servervariables("http_accept_language") & "', http_host = '" &
> request.servervariables("http_host") & "', http_referer = '" &
> request.servervariables("http_referer") & "', http_user_agent = '" &
> request.servervariables("http_user_agent") & "';"
>
> set rs = conn.execute(sql)
>
> even when I change the sql statement to:
> sql = "insert into tbltest testdata = '" & testdata & "';"
> doesn't work either.
>
> All my other pages are working fine - inserting, updating, deleting,
> and selecting.
>
> any help would be greatly appreciated.
>
> Thanx

[Maarten]

accessdate = '" & now() & "',

Besure in mm/dd/yyyy format and surrounded with #01/31/2003#

[Manohar Kamath [MVP]]

The INSERT statement syntax is

INSERT INTO TableName VALUES (... comma separated...);

and if you are specifying field names to insert, then

INSERT INTO TableName (.. comma separated field names...) VALUES (... comma
separated...);


So,

sql = "insert into tbltest (testdata) VALUES ('" & testdata & "');"

should work.

--
Manohar Kamath
Editor, .netWire
[url]www.dotnetwire.com[/url]


"Supaya" <tonyabishop@hcse.ca> wrote in message
news:eaf17c37.0404010807.4f02331a@posting.google.c om...

> Hi,
>
> I'm developing a site with a public and members section. I'm using
> vbscript, asp, and an access database. The login page is processed by
> the members page. If you are a valid member the member page loads.
> If not the member page redirects you to the restricted access page.
>
> On the restricted access page I want to run a script that records
> information about the user trying to login. I'm using environment
> variables for this. The data is captured fine but my sql query isn't
> working. I can't see any restricted words in there and I don't know
> why the script won't run....any help would be appreciated.
>
> script:
>
> sql = "insert into tblfailedlog accessdate = '" & now() & "',
> path_info = '" & request.servervariables("path_info") & "',
> remote_addr = '" & request.servervariables("remote_addr") & "',
> remote_host = '" & request.servervariables("remote_host") & "',
> request_method = '" & request.servervariables("request_method") & "',
> script_name = '" & request.servervariables("script_name") & "',
> server_port = " & request.servervariables("server_port") & ",
> server_port_secure = " & request.servervariables("server_port_secure")
> & ", server_protocol = '" & request.servervariables("server_protocol")
> & "', http_accept_language = '" &
> request.servervariables("http_accept_language") & "', http_host = '" &
> request.servervariables("http_host") & "', http_referer = '" &
> request.servervariables("http_referer") & "', http_user_agent = '" &
> request.servervariables("http_user_agent") & "';"
>
> set rs = conn.execute(sql)
>
> even when I change the sql statement to:
> sql = "insert into tbltest testdata = '" & testdata & "';"
> doesn't work either.
>
> All my other pages are working fine - inserting, updating, deleting,
> and selecting.
>
> any help would be greatly appreciated.
>
> Thanx

[Supaya .]

I've tried writing the sql statement to the sceen and it looks great,
all the data is there. it only fails when I execute it. Then I get
syntax error in insert into .... but it doesn't specify where.



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Supaya .]

I've tried that too with the same results.

:(

*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!