Missing Semicolon Error

Dev Articles Community Forums Sponsor:

Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here

June 2nd, 2006, 11:37 AM

supertommy6

Registered User

Join Date: Jun 2006

Posts: 4

Time spent in forums: 36 m 39 sec
Reputation Power: 0

Missing Semicolon Error

I'm working on a hitcounter for our website, and I'm running into a peculiar error. Here's the code:

Code:

<cfquery datasource="webstats" name="InitialValue">
	INSERT INTO HitCounts( Page, Hit_Count ) 
		VALUES ( '#pagetitle#', 1)
			WHERE NOT EXISTS
				(SELECT * 
					FROM HitCounts
					WHERE Page = '#pagetitle#');
</cfquery>

The error it gives me is:

Quote:

ERROR INFORMATION:
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC Microsoft Access Driver] Missing semicolon (

at end of SQL statement.

SQL = "INSERT INTO HitCounts( Page, Hit_Count ) VALUES ( 'HomePage', 1) WHERE NOT EXISTS (SELECT * FROM HitCounts WHERE Page = 'HomePage');"

Internet searches haven't been very helpful. I'm hoping somebody here knows what might be happening. Thanks for the help!

June 2nd, 2006, 11:56 AM

MadCowDzz

I'm Internet Famous

Dev Articles Frequenter (2500 - 2999 posts)

Join Date: Jan 2003

Location: Toronto, Canada

Posts: 2,890

Time spent in forums: 1 Week 16 h 4 m 48 sec
Reputation Power: 8

Are you able to run that query against your database directly... as in, not from Coldfusion but in your SQL Server?

__________________
Daryl's Homepage | My Blogroll | My Profile | Firefox supporter!
DevArticles Forum Moderator

"The net is a waste of time, and that's exactly what's right about it." -- William Gibson

June 2nd, 2006, 12:00 PM

supertommy6

Registered User

Join Date: Jun 2006

Posts: 4

Time spent in forums: 36 m 39 sec
Reputation Power: 0

I haven't tried that, and I'm honestly not sure how to do it. The datasource is an Access Database. Is there a way to run SQL code in Access?

June 2nd, 2006, 12:44 PM

supertommy6

Registered User

Join Date: Jun 2006

Posts: 4

Time spent in forums: 36 m 39 sec
Reputation Power: 0

It occurs to me that this might not do what I want it to do.

What I'm trying to do is add a hit to the appropriate row. If that row doesn't exist, I need it to create that row with an initial hit value of 1.

This is the code I have:

Code:

<cfquery name="AddHits" datasource="webstats">
		UPDATE HitCounts 
			SET Hit_Count = Hit_Count + 1 
			WHERE Page = '#pagetitle#'
	</cfquery>
	<cfquery datasource="webstats" name="InitialValue">
			INSERT INTO HitCounts( Page, Hit_Count ) 
				VALUES ( '#pagetitle#', 1)
				WHERE NOT EXISTS
					(SELECT * FROM HitCounts WHERE Page = '#pagetitle#');
	</cfquery>

I suppose I could just add each row by hand, but then I will have to do that every time we add a new page.

Let me know if you have any ideas. I really appreciate the help!

June 5th, 2006, 01:08 AM

mail2radhikaraj

Registered User

Join Date: Apr 2006

Posts: 4

Time spent in forums: 2 h 12 m 4 sec
Reputation Power: 0

Missing semicolon error

hey buddy,

there is another way to do an insert in sql .

try this out.

INSERT INTO HitCounts( Page, Hit_Count )
select '#pagetitle#', 1
WHERE NOT EXISTS
(SELECT * FROM HitCounts WHERE Page = '#pagetitle#')

hopefully it should work.
set your parameters in the same way you do when u have values.

lemme know if this works .

regards,
Radz

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: