ASP Classic - SELECT query does not work

[leifoet]

SvAct should be for example : 10

<%
SvAct=(Application("UPDId"))
%>
(a response.wite test from SvAct also gives 10)

However, nothing is selected.
ActId should be also 10
Is the WHERE clause well-coded ?

<%
Dim Conn, rs, sql
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("_private/ABCD.mdb")
Set rs = Server.CreateObject("ADODB.Recordset")
sql = "SELECT * FROM ACTIVITY18 WHERE ActId=" & SVact
rs.Open sql, Conn
%>
Thanks.

 

[SkipVought]

Hi,

Is ActId field Numeric or Text? It could be...

sql = "SELECT * FROM ACTIVITY18 WHERE ActId=‘" & SVact &”’”

Are you sure that SVact contains 10?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[dhookom]

It looks like Skip's code contains the alternative quotes which will cause issues if you copy and paste. If ActID is test, try:

sql = "SELECT * FROM ACTIVITY18 WHERE ActId='" & SVact &"'"

Did you open your database and try create a query with this SQL:

SELECT * FROM ACTIVITY18 WHERE ActId=10

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[SkipVought]

It’s my iPad.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[dhookom]

Skip,
Some devices/apps are way too helpful.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[leifoet]

ActId field => Numeric

I get this error

Microsoft VBScript compilation error '800a0408'
Invalid character

sql = "SELECT * FROM ACTIVITY18 WHERE ActId=‘" & SVact &”’”
----------------------------------------------------------^

 

[leifoet]

For clarity, on my screen, the error arrow points to this ”’” (at the end)
Thanks for help.

 

[SkipVought]

What results from...

SELECT Distinct ActId FROM ACTIVITY18 Where ActId <= 10

Do you get a 10 in that result?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[leifoet]

I receive this error

Microsoft VBScript compilation error '800a0409'
Unterminated string constant
sql = "SELECT Distinct ActId FROM ACTIVITY18 WHERE ActId<=10

Thanks for solution

 

[SkipVought]

sql = "SELECT Distinct ActId FROM ACTIVITY18 WHERE ActId<=10[highlight #FCAF3E]”[/highlight]

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[dhookom]

leifoet,
Always count your symbols that should be in pairs like single & double quotes, parentheses, and other bracketing. There should be an even number or a matching symbol.


Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[guitarzan]

Other activity on this topic here: thread333-1785923