CodeIgniter MSSQL Statement Has Been Terminated

We were spending hours trying to figure out the issues why our result sets weren't completed when returned.
Mins were spent trying to figure out the stored procedure but we were able to identify the issues coming from our php setups over on the web server end. Finally resorted to freetds being the issue. Logs were just pilling up indicating the issues with bad stored procedure writing.

dbutil.c:86:msgno 515: "Cannot insert the value NULL into column 'LaunchDate', table 'tempdb.dbo.#ProductGridView____________________________________________________________________________________________________000000000305'; column does not allow nulls. INSERT fails.

Oh lala! Its fixed!

"You don't make friends with salad.. "

Comments

Post a Comment

Popular posts from this blog

Chat Tu Chak Market

Image
It was 9am in the morning when Cat decided i should get my lazy ass out of bed! lol oh wells .. i should well coz i wanna be early else its going to be hot hot hot coz the market is kinda cramp! From the picture above you can imagine a whole market the size of a 1/2 football field filled with rows of shop of this nature. plus there is poeple cooking in some of the inner stalls and hundreds and thousands of ppl ranging from locals to farang's to other local asians walking around with sweaty bodies! eeww! gosh we got out of the place after 2 hours and we barely covered 50% of the place. there is just so much to shop but mostly they are just fashion shops. yeahs i see people taking pictures in siam paragon so taht they can return home to make and sell at the local markets.. genius aye?
Read more

Rainy Saturday

day 2 today is saturday and i have nothing better to do in life but to just hang around. truthfully speaking i have absolutely no idea what happened today. lol. all i can remember is that i helped mommy and sandra dress for the special day tomorrow in the evening. yeahs graduation and sandra has to work this evening. we had dinner with sharon's parents and i was watching my baby at work. gawd i love this woman. in the afternoon, we went into the city to get contact solutions then we went to rhb bank. then we went to meet arthur for a coffee bean break. how nice isn't it? yeahs, using arthur's notebook to surf the web. from the first glance the ultimate "jealousy" feeling slowly seeping into my blood stream and into my mind. why? don't really know u would have to ask my heart. it happens when u least expected it and when u know your really in love with someone but yet you feel secure but not secure. as we got back, about an hour later sharon's parents arriv
Read more