asp_databases thread: Expected End Of Statement
Message #1 by "Petr Novotny" <pn@b...> on Wed, 28 Nov 2001 09:17:02 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0003_01C177ED.71C86EC0
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: 7bit
RE: [asp_databases] RE: ASP and e-mailHi,
I have a following problem:
This is my SQL command:
SQL= "INSERT into FaultHandling"&_
" (Operator, Date, Time, Contact, Customer, Project, ContactNumber,
ProblemType, Observation, Installer, Name, Email, Date_Time, Fixed,
Solution, CloseBy)"&_
"
valu
es('
"&Op
erat
or&"
','"
&Dat
eH&"
','"
&Tim
eH&"
','"
&Con
tact
Pers
on&"','"&Customer&"','"&ProjNo&"','"&ContactPhone&"','"&ProblemType&"',"&_
"'
"&Ob
serv
atio
n&"'
,'"&
Hand
edOv
er&"
','"
&Nam
e&"'
,'"&Email&"','"&TimeHanded&"','"&Closed&"','"&Solution&"','"&Closedby&"')"
When I try to run it I get the following error:
Can anyone tell me what I'm doing wrong?
Thanks
Petr
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/btnew/fhc/update_fhc.asp, line 85
" va
lues
('"&
Oper
ator
&"',
'"&D
ateH
&"',
'"&T
imeH
&"',
'"&C
onta
ctPe
rson
&"',
'"&C
usto
mer&
"','
"&Pr
ojNo
&"',
'"&C
onta
ctPh
one&
"','
"&Pr
oble
mTyp
e&"'
,'"&
Obse
rvat
ion&
"','
"&Ha
nded
Over
&"',
'"&N
ame&
"','"&Email&"','"&TimeHanded&"','"&Closed&"','"&Solution&"','"&Closedby&"')"
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-^
Message #2 by "Helga Y. Anagnostopoulos" <helga@k...> on Wed, 28 Nov 2001 10:59:17 +0200
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0007_01C177FB.B97C1CE0
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: 7bit
RE: [asp_databases] RE: ASP and e-mailIt's got something to do with your " &
' use - try using only "&Operator&" or '&Operator'
Hope this works
Helga
-----Original Message-----
From: Petr Novotny [mailto:pn@b...]
Sent: Wednesday, November 28, 2001 10:17 AM
To: ASP Databases
Subject: [asp_databases] Expected End Of Statement
Hi,
I have a following problem:
This is my SQL command:
SQL= "INSERT into FaultHandling"&_
" (Operator, Date, Time, Contact, Customer, Project, ContactNumber,
ProblemType, Observation, Installer, Name, Email, Date_Time, Fixed,
Solution, CloseBy)"&_
"
values('"&Operator&"','"&DateH&"','"&TimeH&"','"&ContactPerson&"','"&Custome
r&"','"&ProjNo&"','"&ContactPhone&"','"&ProblemType&"',"&_
"'"&Observation&"','"&HandedOver&"','"&Name&"','"&Email&"','"&TimeHanded&"',
'"&Closed&"','"&Solution&"','"&Closedby&"')"
When I try to run it I get the following error:
Can anyone tell me what I'm doing wrong?
Thanks
Petr
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/btnew/fhc/update_fhc.asp, line 85
"
values('"&Operator&"','"&DateH&"','"&TimeH&"','"&ContactPerson&"','"&Custome
r&"','"&ProjNo&"','"&ContactPhone&"','"&ProblemType&"','"&Observation&"','"&
HandedOver&"','"&Name&"','"&Email&"','"&TimeHanded&"','"&Closed&"','"&Soluti
on&"','"&Closedby&"')"
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-^
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
Message #3 by "Petr Novotny" <pn@b...> on Wed, 28 Nov 2001 10:11:43 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_000D_01C177F5.14DFF900
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: 7bit
RE: [asp_databases] RE: ASP and e-mailHi Helga,
It's sorted. I don't know why but I just had to rename one of the variables
and it works now.
Thanks anyway,
Petr
-----Original Message-----
From: Helga Y. Anagnostopoulos [mailto:helga@k...]
Sent: Wednesday, November 28, 2001 9:59 AM
To: ASP Databases
Subject: [asp_databases] RE: Expected End Of Statement
Importance: High
It's got something to do with your " & ' use - try using only "&Operator&"
or '&Operator'
Hope this works
Helga
-----Original Message-----
From: Petr Novotny [mailto:pn@b...]
Sent: Wednesday, November 28, 2001 10:17 AM
To: ASP Databases
Subject: [asp_databases] Expected End Of Statement
Hi,
I have a following problem:
This is my SQL command:
SQL= "INSERT into FaultHandling"&_
" (Operator, Date, Time, Contact, Customer, Project, ContactNumber,
ProblemType, Observation, Installer, Name, Email, Date_Time, Fixed,
Solution, CloseBy)"&_
"
valu
es('
"&Op
erat
or&"
','"
&Dat
eH&"
','"
&Tim
eH&"
','"
&Con
tact
Pers
on&"','"&Customer&"','"&ProjNo&"','"&ContactPhone&"','"&ProblemType&"',"&_
"'"&
Obse
rvat
ion&
"','
"&Ha
nded
Over
&"',
'"&N
ame&
"','"&Email&"','"&TimeHanded&"','"&Closed&"','"&Solution&"','"&Closedby&"')"
When I try to run it I get the following error:
Can anyone tell me what I'm doing wrong?
Thanks
Petr
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/btnew/fhc/update_fhc.asp, line 85
" va
lues
('"&
Oper
ator
&"',
'"&D
ateH
&"',
'"&T
imeH
&"',
'"&C
onta
ctPe
rson
&"',
'"&C
usto
mer&
"','
"&Pr
ojNo
&"',
'"&C
onta
ctPh
one&
"','
"&Pr
oble
mTyp
e&"'
,'"&
Obse
rvat
ion&
"','
"&Ha
nded
Over
&"',
'"&N
ame&
"','"&Email&"','"&TimeHanded&"','"&Closed&"','"&Solution&"','"&Closedby&"')"
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-^
$subst('Email.Unsub')
Read the future with ebooks at B&N
http
://s
ervi
ce.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid=rn_ebooks
$subst('Email.Unsub')
Read the future with ebooks at B&N
ht
tp:/
/ser
vice.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid=rn_ebooks
Message #4 by "Helga Y. Anagnostopoulos" <helga@k...> on Wed, 28 Nov 2001 12:11:22 +0200
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0015_01C17805.CB228010
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: 7bit
RE: [asp_databases] RE: ASP and e-mailHmm.. I'm happy for you - thinking of
it, it makes sence.
Good Luck
Helga
-----Original Message-----
From: Petr Novotny [mailto:pn@b...]
Sent: Wednesday, November 28, 2001 11:12 AM
To: ASP Databases
Subject: [asp_databases] RE: Expected End Of Statement
Hi Helga,
It's sorted. I don't know why but I just had to rename one of the
variables and it works now.
Thanks anyway,
Petr
-----Original Message-----
From: Helga Y. Anagnostopoulos [mailto:helga@k...]
Sent: Wednesday, November 28, 2001 9:59 AM
To: ASP Databases
Subject: [asp_databases] RE: Expected End Of Statement
Importance: High
It's got something to do with your " & ' use - try using only
"&Operator&" or '&Operator'
Hope this works
Helga
-----Original Message-----
From: Petr Novotny [mailto:pn@b...]
Sent: Wednesday, November 28, 2001 10:17 AM
To: ASP Databases
Subject: [asp_databases] Expected End Of Statement
Hi,
I have a following problem:
This is my SQL command:
SQL= "INSERT into FaultHandling"&_
" (Operator, Date, Time, Contact, Customer, Project,
ContactNumber, ProblemType, Observation, Installer, Name, Email, Date_Time,
Fixed, Solution, CloseBy)"&_
"
values('"&Operator&"','"&DateH&"','"&TimeH&"','"&ContactPerson&"','"&Custome
r&"','"&ProjNo&"','"&ContactPhone&"','"&ProblemType&"',"&_
"'"&Observation&"','"&HandedOver&"','"&Name&"','"&Email&"','"&TimeHanded&"',
'"&Closed&"','"&Solution&"','"&Closedby&"')"
When I try to run it I get the following error:
Can anyone tell me what I'm doing wrong?
Thanks
Petr
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/btnew/fhc/update_fhc.asp, line 85
"
values('"&Operator&"','"&DateH&"','"&TimeH&"','"&ContactPerson&"','"&Custome
r&"','"&ProjNo&"','"&ContactPhone&"','"&ProblemType&"','"&Observation&"','"&
HandedOver&"','"&Name&"','"&Email&"','"&TimeHanded&"','"&Closed&"','"&Soluti
on&"','"&Closedby&"')"
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-^
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
Message #5 by "Tomm Matthis" <matthis@b...> on Wed, 28 Nov 2001 11:29:46 -0500
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_004B_01C177FF.FBBB3380
Content-Type: text/plain;
charset="iso-8859-2"
Content-Transfer-Encoding: 7bit
RE: [asp_databases] RE: ASP and e-mailSounds like there may be an embedded
apostrophe in the field..... You may want to printout the value of the var
to see...
HTHs,
-- Tomm
-----Original Message-----
From: Petr Novotny [mailto:pn@b...]
Sent: Wednesday, November 28, 2001 3:17 AM
To: ASP Databases
Subject: [asp_databases] Expected End Of Statement
Hi,
I have a following problem:
This is my SQL command:
SQL= "INSERT into FaultHandling"&_
" (Operator, Date, Time, Contact, Customer, Project, ContactNumber,
ProblemType, Observation, Installer, Name, Email, Date_Time, Fixed,
Solution, CloseBy)"&_
"
values('"&Operator&"','"&DateH&"','"&TimeH&"','"&ContactPerson&"','"&Custome
r&"','"&ProjNo&"','"&ContactPhone&"','"&ProblemType&"',"&_
"'"&Observation&"','"&HandedOver&"','"&Name&"','"&Email&"','"&TimeHanded&"',
'"&Closed&"','"&Solution&"','"&Closedby&"')"
When I try to run it I get the following error:
Can anyone tell me what I'm doing wrong?
Thanks
Petr
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/btnew/fhc/update_fhc.asp, line 85
"
values('"&Operator&"','"&DateH&"','"&TimeH&"','"&ContactPerson&"','"&Custome
r&"','"&ProjNo&"','"&ContactPhone&"','"&ProblemType&"','"&Observation&"','"&
HandedOver&"','"&Name&"','"&Email&"','"&TimeHanded&"','"&Closed&"','"&Soluti
on&"','"&Closedby&"')"
----------------------------------------------------------------------------
----------------------------------------------------------------------------
-^
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks
|
View Cart
