what I am missing now ? The error in line 57 refers to a different field
than the exception message showing an address "Syntax error (missing
operator) in query _expression_ '2 HOLBOURN CRES'." ????
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft
Access Driver] Syntax error (missing operator) in query _expression_ '2
HOLBOURN CRES'.
The error occurred in C:\Inetpub\wwwroot\HOCACF\pharma\test.cfm: line 57
55 : #qData.SAUTHORITY#,
56 : #qData.SSIGS#,
57 : #qData.SWARDNO# )
58 :
59 : </cfquery>
<cfhttp url="" name="qData" delimiter=","
resolveurl="no" timeout="20"></cfhttp>
<!--- <cfdump var="#qData#"> --->
<cfloop query="qData">
<cfquery datasource="obscript">
INSERT INTO scripts (
SRXNO,
SDISPDATE,
PTITLE,
PFIRSTNAME,
PSURNAME,
PADDRESS,
PSUBURB,
PPOSTCODE,
PMEDICARE,
PMEDICDATE,
PCONCTYPE,
PCONCNO,
PCONCVDATE,
PSAFENTNO,
PREPATNO,
SDOCPRESNO,
SDOCNAME,
SDRUGDESC,
SALTDESC,
SQTY,
SAUTHORITY,
SSIGS,
SWARDNO )
VALUES (
#qData.SRXNO#,
#qData.SDISPDATE#,
#qData.PTITLE#,
#qData.PFIRSTNAME#,
#qData.PSURNAME#,
#qData.PADDRESS#,
#qData.PSUBURB#,
#qData.PPOSTCODE#,
#qData.PMEDICARE#,
#qData.PMEDICDATE#,
#qData.PCONCTYPE#,
#qData.PCONCNO#,
#qData.PCONCVDATE#,
#qData.PSAFENTNO#,
#qData.PREPATNO#,
#qData.SDOCPRESNO#,
#qData.SDOCNAME#,
#qData.SDRUGDESC#,
#qData.SALTDESC#,
#qData.SQTY#,
#qData.SAUTHORITY#,
#qData.SSIGS#,
#qData.SWARDNO# )
</cfquery>
</cfloop>
----------------------------------------------------------------
The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
