Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sunmorgus
  • Order by date
  1. sunmorgus

    Error updating DataRow in DAL object

    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.
  2. sunmorgus

    Error updating DataRow in DAL object

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

    Error updating DataRow in DAL object

    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...
  4. sunmorgus

    Data in TextBox Not Updating

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

    Data in TextBox Not Updating

    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...
  6. sunmorgus

    Dataset to XML/XSLT for Excel Export

    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...
  7. sunmorgus

    Dataset to XML/XSLT for Excel Export

    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...
  8. sunmorgus

    Dataset to XML/XSLT for Excel Export

    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...
  9. sunmorgus

    Help with function / Case statement

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

    Help with function / Case statement

    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...
  11. sunmorgus

    Help with function / Case statement

    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...
  12. sunmorgus

    Help with function / Case statement

    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...
  13. sunmorgus

    Odd message bounce back

    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...
  14. sunmorgus

    AS/400 Dates to Excel

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

    AS/400 Dates to Excel

    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...
  16. sunmorgus

    AS/400 Dates to Excel

    Ok, really starting to get frustrated now...here is my sql output... SELECT FZUNIT as UNIT#, FZSTAT as ST, FZDV# as DIV, '20'||substr(digits(fzdate),5,2)||'/'||substr(digits(fzdate),1,2)||'/'||substr(digits(fzdate),3,2) as FROM_DATE, FZCK# as INVOICE#, FZAGNT as TRUCK, FZVNDR as STOP, FZCITY...
  17. sunmorgus

    AS/400 Dates to Excel

    I will try that myself, but should note that I have had trouble with using a case statement in my sql before. For some reason, only the first when statement would be read by the server. At the time however I was trying to use a len statement, and actually, now that I think about it, I can see...
  18. sunmorgus

    AS/400 Dates to Excel

    PHV...I will try your example on monday when I return to work, and see what my output is...I will convert the user input to a similar string before putting into the sql, and will post the outcome...
  19. sunmorgus

    AS/400 Dates to Excel

    Ok, sorry for the skepticism, but I see your point, and finally understand. The only thing I am worried about is that the original dates on the 400 do not have 4 digit years, but 2 digit years. Also, let me see if I understand correctly...in order for this to work, my user would have to enter a...
  20. sunmorgus

    AS/400 Dates to Excel

    sorry about that, it is getting late in the day for me i suppose... SELECT FZUNIT as UNIT#, FZSTAT as ST, FZDV# as DIV, substr(digits(fzdate),1,2)||'/'||substr(digits(fzdate),3,2)||'/'||substr(digits(fzdate),5,2) as DATE, FZCK# as INVOICE#, FZAGNT as TRUCK, FZVNDR as STOP, FZCITY as CITY...

Part and Inventory Search

Back
Top