Requête SQL 2 tables
Bonjour,
2 tables : contacts / prospection
cle primaire contacts = id_clients
cle primaire prospection =id_prospects
j'ai besoin de mettre à jour les 2 tables en meme temps depuis les données d'un formulaire que je recuperes.
id = Request.QueryString("id")
la requête :
sql = "SELECT contacts.id_clients, prospection.id_clients FROM contacts INNER JOIN prospection ON contacts.id_clients = prospection.id_clients WHERE id_clients=" & id"
erreur retournée :
Unterminated string constant
/test/prospection/maj-contactsOk.asp, line 42
sql = "SELECT contacts.id_clients, prospection.id_clients FROM contacts INNER JOIN prospection ON contacts.id_clients = prospection.id_clients WHERE id_clients=" & id"
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------^
J'ai également essayé avec un SELECT * mais c'est pareil
Si kkun a une idee Svp ?
merci
2 tables : contacts / prospection
cle primaire contacts = id_clients
cle primaire prospection =id_prospects
j'ai besoin de mettre à jour les 2 tables en meme temps depuis les données d'un formulaire que je recuperes.
id = Request.QueryString("id")
la requête :
sql = "SELECT contacts.id_clients, prospection.id_clients FROM contacts INNER JOIN prospection ON contacts.id_clients = prospection.id_clients WHERE id_clients=" & id"
erreur retournée :
Unterminated string constant
/test/prospection/maj-contactsOk.asp, line 42
sql = "SELECT contacts.id_clients, prospection.id_clients FROM contacts INNER JOIN prospection ON contacts.id_clients = prospection.id_clients WHERE id_clients=" & id"
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------^
J'ai également essayé avec un SELECT * mais c'est pareil
Si kkun a une idee Svp ?
merci
5 réponses
-
Tu as oublié un alias dans ton where. Il ne sais pas sur quelle table aller chercher:
sql = "SELECT contacts.id_clients, prospection.id_clients FROM contacts INNER JOIN prospection ON contacts.id_clients = prospection.id_clients WHERE contacts.id_clients=" & id"
A+-
merci mais ........ca marche toujours pas sniiifff
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/test/prospection/maj-contactsOk.asp, line 42
sql = "SELECT contacts.id_clients, prospection.id_clients FROM contacts INNER JOIN prospection ON contacts.id_clients = prospection.id_clients WHERE contacts.id_clients=" & id"
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^ -
@dreadounemummm, t'as pas une accolade en trop à la fin:
essaye ça:
sql = "SELECT contacts.id_clients, prospection.id_clients FROM contacts INNER JOIN prospection ON contacts.id_clients = prospection.id_clients WHERE contacts.id_clients=" & id
-
-
ca progresse mais on y est pas encore :)
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Type mismatch in expression.
/test/prospection/maj-contactsOk.asp, line 44
la ligne 44
conn.Execute sql -
Si peux aider pour m'aider (lol) voici le bout de code
id = Request.QueryString("id")
sql = "SELECT contacts.id_clients, prospection.id_clients FROM contacts INNER JOIN prospection ON contacts.id_clients = prospection.id_clients WHERE contacts.id_clients=" & id "
conn.Execute sql
Set rs = Server.CreateObject("ADODB.RecordSet")
rs.open sql, conn, 3, 3
rs.update
rs.close
Set rs = Nothing
%> -
ca n'inspire toujours personne ?
-
UP
