Guest Weber Posted February 27, 2007 Report Share Posted February 27, 2007 Boa tarde pessoal, estou com um probleminha, ou seja, quero comparar um valor de session dentro de um SQL e esta dando o seguinte erro:Microsoft VBScript compilation error '800a0401' Expected end of statement /site/edit_curriculum.asp, line 20 sql = "select * from Curriculum where c_nome =" Session("c_nome")Se sessão for igua ao o c_nome da tabela Curriculum segue adiante....onde estou errando??Valeu Quote Link to comment Share on other sites More sharing options...
0 .Andreia. Posted February 27, 2007 Report Share Posted February 27, 2007 sql = "select * from Curriculum where c_nome =" & Session("c_nome") Quote Link to comment Share on other sites More sharing options...
0 Guest Weber Posted February 27, 2007 Report Share Posted February 27, 2007 Microsoft JET Database Engine error '80040e10' No value given for one or more required parameters. /site/edit_curriculum.asp, line 22 Quote Link to comment Share on other sites More sharing options...
0 .Andreia. Posted February 27, 2007 Report Share Posted February 27, 2007 ah nome deve ser texto nem vi como chamava a variavel.:sql = "select * from Curriculum where c_nome ='" & Session("c_nome") &"'" Quote Link to comment Share on other sites More sharing options...
0 Guest weber Posted February 27, 2007 Report Share Posted February 27, 2007 agora sim!!!! valeu Quote Link to comment Share on other sites More sharing options...
Question
Guest Weber
Boa tarde pessoal, estou com um probleminha, ou seja, quero comparar um valor de session dentro de um SQL e esta dando o seguinte erro:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/site/edit_curriculum.asp, line 20
sql = "select * from Curriculum where c_nome =" Session("c_nome")
Se sessão for igua ao o c_nome da tabela Curriculum segue adiante....
onde estou errando??
Valeu
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.