[geeklog-devel] MS SQL Upgrade

[Randy Kolenko]

"Select SCOPE_IDENTITY()" is tacked on the end of every insert in the
adapter so that you can get the last insetted identity.. If there is no
identity column, the select SCOPE_IDENTITY() returns null.. No harm.

Seems that there must be a 'qid' value specified for the insert to work.
The true error is that there cannot be a NULL value for the qid column.
We have to add the qid column in the query OR the qid column needs to be
modified to be an identity.



> -----Original Message-----
> From: Michael Jervis [mailto:mjervis at gmail.com] 
> Sent: Friday, May 23, 2008 8:30 AM
> To: Geeklog Development
> Subject: Re: [geeklog-devel] MS SQL Upgrade
> 
> 
> On Fri, May 23, 2008 at 1:18 PM, Randy Kolenko 
> <Randy.Kolenko at nextide.ca> wrote:
> > Double Argh... "Morning eyes" for me..
> > Yes.. Have to replace ' with ''.
> 
> I don't have the morning excuse...
> 
> Now I get:
> 
> The statement has been terminated.: The statement has been terminated.
> - INSERT INTO gl_pollquestions (pid, question) VALUES 
> ('geeklogfeaturepoll','What is the best new feature of 
> Geeklog?'); select SCOPE_IDENTITY()
> 
> However, there is no select SCOPE_IDENTITY() in the upgrade file.
> 
> So what is the adapter layer trying to do and why? 
> _______________________________________________
> geeklog-devel mailing list
> geeklog-devel at lists.geeklog.net 
> http://eight.pairlist.net/mailman/listinfo/geeklog-devel
>