Requête SQL 2 tables
dreadoune
-
Dreadoune Messages postés 141 Statut Membre -
Dreadoune Messages postés 141 Statut Membre -
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
A voir également:
- Requête SQL 2 tables
- Supercopier 2 - Télécharger - Gestion de fichiers
- Tables des matières word - Guide
- 2 ecran pc - Guide
- Faire 2 colonnes sur word - Guide
- Gta 6 trailer 2 - Guide
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+
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+
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
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
%>
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
%>
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question
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"
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------^
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