[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

>