|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
July 23rd, 2003, 09:09 AM
|
|||
|
|||
|
Execution of SQL Request : problem of Recordset
I have got a problem executing a query.
The driver indicates an error in Internet Explorer : No value given for one or more required parameters It refers to the recordset definition. I have tested the query in my DBMS, it works. SOURCE : Dim objConn Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= " & server.mappath (BDname) " Dim StrSQL StrSQL = " SELECT NOM FROM ATTRIBUT WHERE LIBELLE = TRUC" Dim rcdSet rcdSet = Server.CreateObject("ADODB.Recordset") rcdSet.Open StrSQL, objConn , adOpenForwardOnly, adLockPessimistic
|
|
#2
July 23rd, 2003, 11:44 AM
|
||||
|
||||
|
might sound like a stupid question but shouldn't TRUC have ' marks around it like 'TRUC' ?
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Execution of SQL Request : problem of Recordset |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
