Recent content by sunmorgus

Actually, I figured it out. It wasn't the update in the code that was the problem, but a trigger that I added to the table recently. Thanks for the help though.

Is there a better way that I should be doing it?

This is my first time creating a DAL for a website, and I am running into a sort of hairy error. I am attempting to perform an update of a smalldatetime field in my table, but when I do so, I get an error that reads: Conversion failed when converting character string to smalldatetime data type...

OMG, thank you. I can't believe I missed that! I guess I am more of a newb than I thought! Hehe!

Ok, here is the skinny. I have a textbox on a webform (asp.net 2.0) that has it's text property set on load to data from a sqldatareader (I read the data into a string variable, then sent the text property equal to the string variable). This is working well, except for one problem, I want to be...

Basically, it just needs to dump the data into the spreadsheet. I don't need any formatting or anything like that, no special styles, or anything at all...

Ok, so here is the deal. I have a dataset that I want to export to excel using XML/XSLT. I have a fairly general idea about how all of this should work, and have found many resources on the 'net, but none seem to really get me going on how this whole thing should work. So here is what I...

Ok, so here is the deal. I have a dataset that I want to export to excel using XML/XSLT. I have a fairly general idea about how all of this should work, and have found many resources on the 'net, but none seem to really get me going on how this whole thing should work. So here is what I...

Yeah, I tried it and it works for me now. Thanks!

Catadmin, you were correct with your reply, I noticed it just before I read your reply, to use the Set statement before the Case, although, I didn't need to add the select at the beginning of the case. I am getting the same kind of weird output where it is only returning 7 characters, so I will...

Thank you Alex, I tried that, and it seemed to help, it trimmed the error message down some, but I still get this: Msg 156, Level 15, State 1, Procedure fn_FixSSN, Line 6 Incorrect syntax near the keyword 'CASE'. Msg 102, Level 15, State 1, Procedure fn_FixSSN, Line 15 Incorrect syntax near...

I am having an issue getting a case statement to work withing a custom function that I am writing to add dashes to a SSN within my application. I have written the function as such: USE HRDev GO CREATE FUNCTION dbo.fn_FixSSN (@SSN as char(11)) RETURNS char(11) AS BEGIN CASE LEN(@SSN) WHEN...

I have a client on my network that is trying to send an email out to a customer and she is getting a rather odd error message/bounce back whenever she sends the message (note: I changed the @ in the email address under final recipient). No other client on the network gets this error when sending...

Thank you all again so much for your help. Stars for each...

Ok, I figured it out...when I converted the user inputed dates, I forgot to put the "/"'s in..hehe! Here is the completed code if anyone is interested... [code] Option Explicit Dim adAS400Conn As ADODB.Connection Sub GetData() 'On Error GoTo handleerrors Dim adFZFUELRs As ADODB.Recordset Dim...