Missing semicolon (;)

**hugheshi** · 08-09-2005, 11:26

codice:

Error Type:
Microsoft JET Database Engine (0x80040E14)
 /viaggi/prenotazione_exe.asp, line 186

ho il seguente errore ma non capisco se metto ; mi risponde con

codice:

Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/viaggi/prenotazione_exe.asp, line 186, column 17

la insert che faccio è la seguente :

codice:

	qry ="INSERT INTO richieste"&_
	" VALUES (luogo = '"&luogo&"'), (nome = '"&nome&"'), (cognome = '"&cognome&"'), (codice = "&codice&"), (email = '"&email&"'), (telefono="&telefono&"), (cellulare ="&cellulare&"), (ente='"&ente&"'), (settore = '"&settore&"'), (data_ins='"&data_ins&"'), (anno='"&anno&"') , (motivo='"&motivo&"'), (hotel1='"&hotel1&"')"&_
conn.execute(qry);

**kalosjo** · 08-09-2005, 11:49

Originariamente inviato da hugheshi

codice:

	qry ="INSERT INTO richieste"&_
	" VALUES (luogo = '"&luogo&"'), (nome = '"&nome&"'), (cognome = '"&cognome&"'), (codice = "&codice&"), (email = '"&email&"'), (telefono="&telefono&"), (cellulare ="&cellulare&"), (ente='"&ente&"'), (settore = '"&settore&"'), (data_ins='"&data_ins&"'), (anno='"&anno&"') , (motivo='"&motivo&"'), (hotel1='"&hotel1&"')"
conn.execute(qry);

**hugheshi** · 08-09-2005, 11:57

ma se devo andare a capo ?
con"&_ poi come diventa ?

**hugheshi** · 08-09-2005, 14:15

codice:

CNN=Application("CNN")

	set conn=Server.CreateObject("ADODB.Connection")
	conn.open CNN 
	
	Set rs1 = Server.CreateObject("ADODB.Recordset")
	qry1=" select * from autorita where ente = '"& ente &"' and settore = '"& settore &"'"
	rs1.Open qry1,conn
	if rs1.eof then
	do until rs1.eof 
	rs1.movenext 
	loop
	end if 

'verifica che esistano i destinatari 
'caso 1
	if rs1.fields("mail_seg_settore") <> "" and  rs1.fields("mail_dir_settore") <> ""  then

	'fa la insert sul db 
	
	qryx ="INSERT INTO richieste VALUES (luogo = '"&luogo&"'), (nome = '"&nome&"'), (cognome = '"&cognome&"'), (codice = "&codice&"), (email = '"&email&"'), (telefono="&telefono&"), (cellulare ="&cellulare&"), (ente='"&ente&"'), (settore = '"&settore&"'), (data_ins='"&data_ins&"'), (anno='"&anno&"') , (motivo='"&motivo&"'), (hotel1='"&hotel1&"')"&_
	"(lochotel1='"&lochotel1&"'), (datarrhtl1='"&datarrhtl1&"'), (dataparthtl1='"&dataparthtl1&"'), (pernhotel1='"&pernhotel1&"'), (hotel2='"&hotel2&"'), (lochotel2='"&lochotel2&"'), (datarrhtl2='"&datarrhtl2&"'), (dataparthtl2='"&dataparthtl2&"'), (pernhotel2='"&pernhotel2&"'), (hotel3='"&hotel3&"'), (lochotel3='"&lochotel3&"')"&_
	"(datarrhtl3='"&datarrhtl3&"'), (dataparthtl3='"&dataparthtl3&"'), (pernhotel3='"&pernhotel3&"'), (volda1='"&volda1&"'), (datavol1='"&datavol1&"'), (volh1a='"&volh1a&"'), (vola1='"&vola1&"'), (datarrv1='"&datarrv1&"'), (volh1r='"&volh1r&"'), (volda2='"&volda2&"'), (datavol2='"&datavol2&"'), (volh2a='"&volh2a&"'), (vola2='"&vola2&"')"&_
	"(datarrv2='"&datarrv2&"'), (volh2r='"&volh2r&"'), (volda3='"&volda3&"'), (datavol3='"&datavol3&"'), (volh3a='"&volh3a&"'), (vola3='"&vola3&"'), (datarrv3='"&datarrv3&"'), (volh3r='"&volh3r&"'), (volda4='"&volda4&"'), (datavol4='"&datavol4&"'), (volh4a='"&volh4a&"'), (vola4='"&vola4&"'), (datarrv4='"&datarrv4&"'), (volh4r='"&volh4r&"')"&_
	"(datrain1='"&datrain&"'), (datatrain1p='"&datatrain1p&"'), (htrainp1='"&htrainp1&"'), (atrain1='"&atrain1&"'), (datatrain1a='"&datatrain1a&"'), (htraina1='"&htraina1&"'), (datrain2='"&datrain2&"'), (datatrain2p='"&datatrain2p&"'), (htrainp2='"&htrainp2&"'), (atrain2='"&atrain2&"'), (datatrain2a='"&datatrain2a&"'), (htraina2='"&htraina2&"')"&_
	"(datrain3='"&datrain3&"'), (datatrain3p='"&datatrain3p&"'), (htrainp3='"&htrainp3&"'), (atrain3='"&atrain3&"'), (datatrain3a='"&datatrain3a&"'), (htraina3='"&htraina3&"') , (datrain4='"&datrain4&"'), (datatrain4p='"&datatrain4p&"'), (htrainp4='"&htrainp4&"'), (atrain4='"&atrain4&"'), (datatrain4a='"&datatrain4a&"'), (htraina4='"&htraina4&"')"&_
	"(costotrain4='"&costotrain4&"'), (autoda1='"&autoda1&"'), (nolodata1='"&nolodata1&"'), (noloh1='"&noloh1&"'), (autoa1='"&autoa1&"'), (nolodatar1='"&nolodatar1&"'), (nolohr1='"&nolohr1&"'),  (gruppo1='"&gruppo1&"'), (autoda2='"&autoda2&"'), (nolodata2='"&nolodata2&"'), (noloh2='"&noloh2&"'), (autoa2='"&autoa2&"'), (nolodatar2='"&nolodatar2&"')"&_
	"(nolohr2 ='"&nolohr2&"'), (gruppo2='"&gruppo2&"'), (autoda3='"&autoda3&"'), (nolodata3='"&nolodata3&"'), (noloh3='"&noloh3&"'), (autoa3='"&autoa3&"'), (nolodatar3='"&nolodatar3&"'), (nolohr3='"&nolohr3&"'), (gruppo3='"&gruppo3&"'), (autoda4='"&autoda4&"'), (nolodata4='"&nolodata4&"'), (noloh4='"&noloh4&"'), (autoa4='"&autoa4&"'), (nolodatar4='"&nolodatar4&"')"&_
	"(nolohr4 = '"&nolohr4&"'), (gruppo4='"&gruppo4&"') ,(autop='"&autop&"'), (marca='"&marca&"'), (tipo='"&tipo&"'), (cilindrata='"&cilindrata&"'), (stkm='"&stkm&"'), (stato='"&stato&"')"	
	
	conn.execute(qryx); 
	end if
	
	conn.close
	conn=nothing

**kalosjo** · 08-09-2005, 15:23

Scusa ma non aveo letto la query.

Hai sbagliato la sintassi!!!

La sintassi della insert è:

INSERT INTO TABELLA (ELENCO, CAMPI, SEPARATI, DA, VIRGOLE) VALUES (ELENCO, VALORI, SEPARATI, DA, VIRGOLE)

In cui il numero dei valore DEVE corrispondere al numero dei campi.

**hugheshi** · 08-09-2005, 15:31

ok ma come faccio ad andare a capo ?
es

(ho riscritto la query)

codice:

qryx ="INSERT INTO richieste (luogo, nome, cognome, codice, ente, data_ins, settore, telefono, cellulare, email, motivo"&_
	"hotel1, lochotel1,	datarrhtl1, dataparthtl1, pernhotel1"&_
	"hotel2, lochotel2, datarrhtl2, dataparthtl2, pernhotel2"&_
	"hotel3, lochotel3, datarrhtl3, dataparthtl3, pernhotel3"&_
	"volda1, datavol1, volh1a, vola1, datarrv1, volh1r"&_
	"volda2, datavol2, volh2a, vola2, datarrv2, volh2r"&_
	"volda3, datavol3,volh3a,vola3, datarrv3, volh3r"&_
	"volda4, datavol4, volh4a, vola4, datarrv4, volh4r"&_
	"datrain1, datatrain1p, htrainp1, atrain1, datatrain1a, htraina1"&_
	"datrain2, datatrain2p, htrainp2, atrain2, datatrain2a, htraina2"&_
	"datrain3, datatrain3p, htrainp3, atrain3, datatrain3a, htraina3"&_
	"datrain4, datatrain4p, htrainp4, atrain4, datatrain4a, htraina4"&_
	"autoda1, nolodata1, noloh1, autoa1, nolodatar1, nolohr1, gruppo1"&_
	"autoda2, nolodata2, noloh2, autoa2, nolodatar2, nolohr2, gruppo2"&_
	"autoda3, nolodata3, noloh3, autoa3, nolodatar3, nolohr3, gruppo3"&_
	"autoda4, nolodata4, noloh4, autoa4, nolodatar4, nolohr4, gruppo4"&_
	"autop, marca, tipo, cilindrata, stkm, stato"&_
	"SELECT  '"&luogo&"' ,'"&nome&"', '"&cognome&"', '"&codice&"', '"&email&"', "&telefono&", "&cellulare&",'"&ente&"', '"&settore&"', '"&data_ins&"', '"&anno&"' , '"&motivo&"'"&_
	"'"&hotel1&"', '"&lochotel1&"', '"&datarrhtl1&"', '"&dataparthtl1&"', '"&pernhotel1&"'"&_
	"'"&hotel2&"', '"&lochotel2&"', '"&datarrhtl2&"', '"&dataparthtl2&"', '"&pernhotel2&"'"&_
	"'"&hotel3&"', '"&lochotel3&"', '"&datarrhtl3&"', '"&dataparthtl3&"', '"&pernhotel3&"'"&_
	"'"&volda1&"', '"&datavol1&"', '"&volh1a&"', '"&vola1&"', '"&datarrv1&"', '"&volh1r&"'"&_
	"'"&volda2&"', '"&datavol2&"', '"&volh2a&"', '"&vola2&"', '"&datarrv2&"', '"&volh2r&"'"&_
	"'"&volda3&"', '"&datavol3&"', '"&volh3a&"', '"&vola3&"', '"&datarrv3&"', '"&volh3r&"'"&_
	"'"&volda4&"', '"&datavol4&"', '"&volh4a&"', '"&vola4&"', '"&datarrv4&"', '"&volh4r&"'"&_
	"'"&datrain&"', '"&datatrain1p&"', '"&htrainp1&"', '"&atrain1&"', '"&datatrain1a&"', '"&htraina1&"'"&_
	"'"&datrain2&"', '"&datatrain2p&"', '"&htrainp2&"', '"&atrain2&"', '"&datatrain2a&"', '"&htraina2&"'"&_
	"'"&datrain3&"', '"&datatrain3p&"', '"&htrainp3&"', '"&atrain3&"', '"&datatrain3a&"', '"&htraina3&"'"&_
	"'"&datrain4&"', '"&datatrain4p&"', '"&htrainp4&"', '"&atrain4&"', '"&datatrain4a&"', '"&htraina4&"'"&_
	"'"&autoda1&"', '"&nolodata1&"', '"&noloh1&"', '"&autoa1&"', '"&nolodatar1&"', '"&nolohr1&"', '"&gruppo1&"'"&_
	"'"&autoda2&"', '"&nolodata2&"', '"&noloh2&"', '"&autoa2&"', '"&nolodatar2&"', '"&nolohr2&"', '"&gruppo2&"'"&_
	"'"&autoda3&"', '"&nolodata3&"', '"&noloh3&"', '"&autoa3&"', '"&nolodatar3&"', '"&nolohr3&"', '"&gruppo3&"'"&_
	"'"&autoda4&"', '"&nolodata4&"', '"&noloh4&"', '"&autoa4&"', '"&nolodatar4&"', '"&nolohr4&"', '"&gruppo4&"'"&_
	"'"&autop&"', '"&marca&"', '"&tipo&"', '"&cilindrata&"', '"&stkm&"', '"&stato&"';"	
	
	conn.execute(qryx)

**kalosjo** · 08-09-2005, 15:41

La query era sbagliata, te la scrivo io:

codice:

qryx ="INSERT INTO richieste (luogo, nome, cognome, codice, ente, data_ins, settore, telefono, cellulare, email, motivo"&_
	"hotel1, lochotel1,	datarrhtl1, dataparthtl1, pernhotel1"&_
	"hotel2, lochotel2, datarrhtl2, dataparthtl2, pernhotel2"&_
	"hotel3, lochotel3, datarrhtl3, dataparthtl3, pernhotel3"&_
	"volda1, datavol1, volh1a, vola1, datarrv1, volh1r"&_
	"volda2, datavol2, volh2a, vola2, datarrv2, volh2r"&_
	"volda3, datavol3,volh3a,vola3, datarrv3, volh3r"&_
	"volda4, datavol4, volh4a, vola4, datarrv4, volh4r"&_
	"datrain1, datatrain1p, htrainp1, atrain1, datatrain1a, htraina1"&_
	"datrain2, datatrain2p, htrainp2, atrain2, datatrain2a, htraina2"&_
	"datrain3, datatrain3p, htrainp3, atrain3, datatrain3a, htraina3"&_
	"datrain4, datatrain4p, htrainp4, atrain4, datatrain4a, htraina4"&_
	"autoda1, nolodata1, noloh1, autoa1, nolodatar1, nolohr1, gruppo1"&_
	"autoda2, nolodata2, noloh2, autoa2, nolodatar2, nolohr2, gruppo2"&_
	"autoda3, nolodata3, noloh3, autoa3, nolodatar3, nolohr3, gruppo3"&_
	"autoda4, nolodata4, noloh4, autoa4, nolodatar4, nolohr4, gruppo4"&_
	"autop, marca, tipo, cilindrata, stkm, stato) "&_
	"VALUES  ('"&luogo&"' ,'"&nome&"', '"&cognome&"', '"&codice&"', '"&email&"', "&telefono&", "&cellulare&",'"&ente&"', '"&settore&"', '"&data_ins&"', '"&anno&"' , '"&motivo&"'"&_
	"'"&hotel1&"', '"&lochotel1&"', '"&datarrhtl1&"', '"&dataparthtl1&"', '"&pernhotel1&"'"&_
	"'"&hotel2&"', '"&lochotel2&"', '"&datarrhtl2&"', '"&dataparthtl2&"', '"&pernhotel2&"'"&_
	"'"&hotel3&"', '"&lochotel3&"', '"&datarrhtl3&"', '"&dataparthtl3&"', '"&pernhotel3&"'"&_
	"'"&volda1&"', '"&datavol1&"', '"&volh1a&"', '"&vola1&"', '"&datarrv1&"', '"&volh1r&"'"&_
	"'"&volda2&"', '"&datavol2&"', '"&volh2a&"', '"&vola2&"', '"&datarrv2&"', '"&volh2r&"'"&_
	"'"&volda3&"', '"&datavol3&"', '"&volh3a&"', '"&vola3&"', '"&datarrv3&"', '"&volh3r&"'"&_
	"'"&volda4&"', '"&datavol4&"', '"&volh4a&"', '"&vola4&"', '"&datarrv4&"', '"&volh4r&"'"&_
	"'"&datrain&"', '"&datatrain1p&"', '"&htrainp1&"', '"&atrain1&"', '"&datatrain1a&"', '"&htraina1&"'"&_
	"'"&datrain2&"', '"&datatrain2p&"', '"&htrainp2&"', '"&atrain2&"', '"&datatrain2a&"', '"&htraina2&"'"&_
	"'"&datrain3&"', '"&datatrain3p&"', '"&htrainp3&"', '"&atrain3&"', '"&datatrain3a&"', '"&htraina3&"'"&_
	"'"&datrain4&"', '"&datatrain4p&"', '"&htrainp4&"', '"&atrain4&"', '"&datatrain4a&"', '"&htraina4&"'"&_
	"'"&autoda1&"', '"&nolodata1&"', '"&noloh1&"', '"&autoa1&"', '"&nolodatar1&"', '"&nolohr1&"', '"&gruppo1&"'"&_
	"'"&autoda2&"', '"&nolodata2&"', '"&noloh2&"', '"&autoa2&"', '"&nolodatar2&"', '"&nolohr2&"', '"&gruppo2&"'"&_
	"'"&autoda3&"', '"&nolodata3&"', '"&noloh3&"', '"&autoa3&"', '"&nolodatar3&"', '"&nolohr3&"', '"&gruppo3&"'"&_
	"'"&autoda4&"', '"&nolodata4&"', '"&noloh4&"', '"&autoa4&"', '"&nolodatar4&"', '"&nolohr4&"', '"&gruppo4&"'"&_
	"'"&autop&"', '"&marca&"', '"&tipo&"', '"&cilindrata&"', '"&stkm&"', '"&stato&"')"	
	
	conn.execute(qryx)

Tu vuoi sapere se funziona " & _" per andare a capo come in Visual Basic?

**hugheshi** · 08-09-2005, 15:47

si

**hugheshi** · 08-09-2005, 15:50

perchè l'errore è lì
quando esegue la qry
mi unisce :

codice:

	qryx ="INSERT INTO richieste (luogo, nome, cognome, codice, email, telefono, cellulare, ente, settore, data_ins, anno, motivo"&_
	"hotel1 , lochotel1,	datarrhtl1, dataparthtl1, pernhotel1"&_

e infatti mi da l'errore :

codice:

The INSERT INTO statement contains the following unknown field name: 'motivohotel1'. Make sure you have typed the name correctly, and try the operation again.

**kalosjo** · 08-09-2005, 15:53

Mancano le virgole alla fine di ogni riga.....

codice:

qryx ="INSERT INTO richieste (luogo, nome, cognome, codice, ente, data_ins, settore, telefono, cellulare, email, motivo, "&_
	"hotel1, lochotel1,	datarrhtl1, dataparthtl1, pernhotel1, "&_
	"hotel2, lochotel2, datarrhtl2, dataparthtl2, pernhotel2, "&_
	"hotel3, lochotel3, datarrhtl3, dataparthtl3, pernhotel3, "&_
	"volda1, datavol1, volh1a, vola1, datarrv1, volh1r, "&_
	"volda2, datavol2, volh2a, vola2, datarrv2, volh2r, "&_
	"volda3, datavol3,volh3a,vola3, datarrv3, volh3r, "&_
	"volda4, datavol4, volh4a, vola4, datarrv4, volh4r, "&_
	"datrain1, datatrain1p, htrainp1, atrain1, datatrain1a, htraina1, "&_
	"datrain2, datatrain2p, htrainp2, atrain2, datatrain2a, htraina2, "&_
	"datrain3, datatrain3p, htrainp3, atrain3, datatrain3a, htraina3, "&_
	"datrain4, datatrain4p, htrainp4, atrain4, datatrain4a, htraina4, "&_
	"autoda1, nolodata1, noloh1, autoa1, nolodatar1, nolohr1, gruppo1, "&_
	"autoda2, nolodata2, noloh2, autoa2, nolodatar2, nolohr2, gruppo2, "&_
	"autoda3, nolodata3, noloh3, autoa3, nolodatar3, nolohr3, gruppo3, "&_
	"autoda4, nolodata4, noloh4, autoa4, nolodatar4, nolohr4, gruppo4, "&_
	"autop, marca, tipo, cilindrata, stkm, stato) "&_
	"VALUES  ('"&luogo&"' ,'"&nome&"', '"&cognome&"', '"&codice&"', '"&email&"', "&telefono&", "&cellulare&",'"&ente&"', '"&settore&"', '"&data_ins&"', '"&anno&"' , '"&motivo&"', "&_
	"'"&hotel1&"', '"&lochotel1&"', '"&datarrhtl1&"', '"&dataparthtl1&"', '"&pernhotel1&"', "&_
	"'"&hotel2&"', '"&lochotel2&"', '"&datarrhtl2&"', '"&dataparthtl2&"', '"&pernhotel2&"', "&_
	"'"&hotel3&"', '"&lochotel3&"', '"&datarrhtl3&"', '"&dataparthtl3&"', '"&pernhotel3&"', "&_
	"'"&volda1&"', '"&datavol1&"', '"&volh1a&"', '"&vola1&"', '"&datarrv1&"', '"&volh1r&"', "&_
	"'"&volda2&"', '"&datavol2&"', '"&volh2a&"', '"&vola2&"', '"&datarrv2&"', '"&volh2r&"', "&_
	"'"&volda3&"', '"&datavol3&"', '"&volh3a&"', '"&vola3&"', '"&datarrv3&"', '"&volh3r&"', "&_
	"'"&volda4&"', '"&datavol4&"', '"&volh4a&"', '"&vola4&"', '"&datarrv4&"', '"&volh4r&"', "&_
	"'"&datrain&"', '"&datatrain1p&"', '"&htrainp1&"', '"&atrain1&"', '"&datatrain1a&"', '"&htraina1&"', "&_
	"'"&datrain2&"', '"&datatrain2p&"', '"&htrainp2&"', '"&atrain2&"', '"&datatrain2a&"', '"&htraina2&"', "&_
	"'"&datrain3&"', '"&datatrain3p&"', '"&htrainp3&"', '"&atrain3&"', '"&datatrain3a&"', '"&htraina3&"', "&_
	"'"&datrain4&"', '"&datatrain4p&"', '"&htrainp4&"', '"&atrain4&"', '"&datatrain4a&"', '"&htraina4&"', "&_
	"'"&autoda1&"', '"&nolodata1&"', '"&noloh1&"', '"&autoa1&"', '"&nolodatar1&"', '"&nolohr1&"', '"&gruppo1&"', "&_
	"'"&autoda2&"', '"&nolodata2&"', '"&noloh2&"', '"&autoa2&"', '"&nolodatar2&"', '"&nolohr2&"', '"&gruppo2&"', "&_
	"'"&autoda3&"', '"&nolodata3&"', '"&noloh3&"', '"&autoa3&"', '"&nolodatar3&"', '"&nolohr3&"', '"&gruppo3&"', "&_
	"'"&autoda4&"', '"&nolodata4&"', '"&noloh4&"', '"&autoa4&"', '"&nolodatar4&"', '"&nolohr4&"', '"&gruppo4&"', "&_
	"'"&autop&"', '"&marca&"', '"&tipo&"', '"&cilindrata&"', '"&stkm&"', '"&stato&"')"

Discussione: Missing semicolon (;)

Strumenti discussione

Ricerca discussione

Visualizza

Missing semicolon (;)

Re: Missing semicolon (;)

Permessi di invio