Last post Mar 17, 2010 04:07 PM by Myersra
Mar 13, 2010 11:46 AM|Myersra|LINK
I am setting up the classifieds starter kit and I am getting the error "Incorrect syntax near '='. Must declare the scalar variable "@DateApproved"."
when executing the SQL script to setup the classifieds DB.
I followed the help posted on this forum (thanks
darkknight187), but I am still getting this error.
I am using Go Daddy for hosting
IIS 7.0 (in classic mode)
I created both DBs, then deleted the tables, views, and procedures from the classifieds DB
Modfied the "@DateCreated smalldatetime = NULL" text in the sql file as reco'd
classified ads starter kit
Classified's starter kit
Mar 14, 2010 07:35 AM|cnranasinghe|LINK
Better submit the code.
Mar 15, 2010 08:15 PM|racer184|LINK
I do not understand your error. But there are two big things I learned.
Select 'classic pipeline' (as you did)
And no matter what I did, I had to use the database publisher function in VisualStudio 2005 to get
my sites to work. I never figured out why the database publisher thing would not work in Visual Studio
2008, I just went back and used the scripts from 2005. The errors I am talking about here happen when
trying to run the scripts on the godaddy database.
If you have not gotten a lot of work into your site yet, then do what I did on one of mine...
I canceled the hosting account, then set it up again but this time with IIS 6.
Since you are using godaddy hosting, you will also find that you have a great deal of trouble with the
site sending emails. There are many threads on that subject here on this forum that I suggest you read.
Mar 17, 2010 04:07 PM|Myersra|LINK
II found information taht it may be the file encoding saved out of notepad (used to edit SQL file) so I changed it to UTF-8 and still had the error. I then used the original SQL file (no edit for the @DateCreated text) and it worked fine.
Thanks for th ereplies