BlogCFC Update

Today's update contains two small changes. First, I removed the need to actually type anything in the search box. A user was trying to use the search page to browse categories and kept getting bounced to the home page when he didn't enter anything. It seemed like a fair change to make, so that's done.

Second, a fix to tweetbacks was put it. Thanks to Shaun for the fix.

TweetBacks
Comments
Travis's Gravatar Ray,
Downloaded the newest version....006 and get errors when creating the db through SQL Query Anylazer in MSSQL....here are the results. Am I doing something wrong?

Thanks
- Travis

Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 9
Line 9: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 9
Line 9: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 11
Line 11: Incorrect syntax near 'max'.
Server: Msg 170, Level 15, State 1, Line 8
Line 8: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near '('.

(1 row(s) affected)


(1 row(s) affected)


(1 row(s) affected)


(1 row(s) affected)


(1 row(s) affected)


(1 row(s) affected)


(1 row(s) affected)
# Posted By Travis | 4/6/10 3:59 AM
Raymond Camden's Gravatar Line 11? In my /install/sqlserver.sql file that is a comment. Is it for you?
# Posted By Raymond Camden | 4/6/10 4:05 AM
Travis's Gravatar Should

--
-- Definition for table tblblogcomments :
--

be commented as

/******
-- Definition for table tblblogcomments :
******/
# Posted By Travis | 4/6/10 4:25 AM
Raymond Camden's Gravatar No idea - I believe I generated the script via Ent Mgr many moons ago. For now, try removing ALL comments. If it works, shoot me back the script and I'll commit to SVN.
# Posted By Raymond Camden | 4/6/10 4:27 AM
Travis's Gravatar Comments all removed....
Same, starts at line 7 instead...here's the first line

Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near 'max'.
# Posted By Travis | 4/6/10 4:53 AM
Raymond Camden's Gravatar Can you post the first 10 lines of the script now?
# Posted By Raymond Camden | 4/6/10 4:54 AM
Kal's Gravatar @Travis

Which MSSQL DB are you suing? SQL2000 or 2005? If 2000 then change nvarchar(max) to nvarchar(4000).
# Posted By Kal | 4/14/10 11:27 AM
BlogCFC was created by Raymond Camden. This blog is running version 5.9.6.001. Contact Blog Owner