BlogCFC Update

Posted At : April 3, 2010 10:23 AM | Posted By : Raymond Camden
Related Categories: BlogCFC

Today's update contains two small changes. First, I removed the need to actually type anything in site. 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.

Comments Comments (7) | Print Print | Send Send | 1127 Views | Bookmark and Share
TweetBacks

Comments
[Add Comment] [Subscribe to 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
[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.9.6.001. Contact Blog Owner