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!

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

Recent content by Reynet01

  1. Reynet01

    response.write error

    Thanks Everyone that did the trick DotnetGnat the last bit of code is now putting the value in the email and I will also remove the plus signs and replace with ampersands like I am supposed to. If knowledge were power I would be a AAA battery!
  2. Reynet01

    response.write error

    Ok here is what I have with no errors I am trying to put the "VALUE" in this line of the email but it never shows my value MyBody =Mybody & "Product Registered: " + nm(1) & value & vbCrLf I tried call setOptionsValue() instead of value <% function setOptionsValue() Dim value SELECT Case...
  3. Reynet01

    response.write error

    Ok I used this and I get no errors but when I am sending the email out I don't get the value <% function setOptionsValue() Dim options SELECT Case request.form("radiogroup3") Case 0: value= "Basic" case 1: value="with email module" case 2: value= "with fax module" case 3: value="with...
  4. Reynet01

    response.write error

    this is probably so easy it's silly for me to ask but I keep getting errors with the below code what am I doing wrong <% options= <%if request.form("radiogroup3")="0" then response.write "Basic" Else if request.form("radiogroup3")="1" then response.write "with print module" Else if...
  5. Reynet01

    Sending current date in cdonts I keep getting errors

    Thanks that was simple I was using + instead of & on previous attempts. I guess I need to stop using that. If knowledge were power I would be a AAA battery!
  6. Reynet01

    Sending current date in cdonts I keep getting errors

    I tried using MyBody = MyBody & "Date code was generated: " Date() & vbCrLf But I get the following error: Microsoft VBScript compilation error '800a0401' Expected end of statement /disttemp/result.asp, line 251 MyBody = MyBody & "Date code was generated: " Date() & vbCrLf...
  7. Reynet01

    Sending current date in cdonts I keep getting errors

    Trying to send e-mail using CDONTS but I keep getting eeror when I try and add the current date to one of the body lines MyBody = MyBody & "Date code was generated: " + =date() & vbCrLf Here is the full code- Thanks for any help <% email=session("x_email") site= sitecode Machine=...
  8. Reynet01

    How Do I Add leading Zeros to nvarchar field in query?

    Sorry roccorocks your code works as well I just tried SQLDenis's post first and it achieved my goal. If knowledge were power I would be a AAA battery!
  9. Reynet01

    How Do I Add leading Zeros to nvarchar field in query?

    Thanks you guys are a life saver If knowledge were power I would be a AAA battery!
  10. Reynet01

    How Do I Add leading Zeros to nvarchar field in query?

    Here is what I have for the statement Select Right('00000000' + SID, 8) From [dbo].[Users] Order By SID Desc information is stored as charecters. The above statement adds the leading zeros as it should but I need to sort these values in order and since they are stored as text they still show...
  11. Reynet01

    How Do I Add leading Zeros to nvarchar field in query?

    OOPs it still shows the numbers out of order is there any way to have this convert it to a number If knowledge were power I would be a AAA battery!
  12. Reynet01

    How Do I Add leading Zeros to nvarchar field in query?

    Thanks it works great, so simple but so far out of my knowledge grasp If knowledge were power I would be a AAA battery!
  13. Reynet01

    How Do I Add leading Zeros to nvarchar field in query?

    I have a field called SID it is a maximum of 8 characters I need to add leading zeros to the front of the text if it is not 8 characters long Example: 1234 needs to be 00001234 How is this done so that it pulls data in the correct format in a sql query? Thanks for any help you can give. If...
  14. Reynet01

    Update Hidden Value on the Fly?

    I have a form with input input fields 1. A drop down box of current customers "ClientSelect" 2. a text field to enter new customers "Clienttext" 3. A hidden field "ClientHidden" Below is the value for this field <input name="clienthidden" type="hidden" id="clienthidden" value="<% If...
  15. Reynet01

    Export to File

    Sorry I thought I had done that but I must not have hit the confirm link to activate it. Thanks Again DotNetGnat If knowledge were power I would be a AAA battery!

Part and Inventory Search

Back
Top