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 bkrike 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: Reynet01
  • Content: Threads
  • Order by date
  1. 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...
  2. 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=...
  3. 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...
  4. 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...
  5. Reynet01

    Export to File

    I have a response.write statement on my page that writes out a license code string which looks like this [RTAuth] XXXXXXX=RTVoiceLines=0120-XXXXXXXXXX Here is the code...
  6. Reynet01

    Object Required&quot; ?

    Can someone tell me what is wrong here I don't do this enough to be good at it and I am pulling my hair out! Thanks <% Dim LicenseLookup1__tpclic LicenseLookup1__tpclic = "%" If (Request.form("frmtpclicense") <> "") Then LicenseLookup1__tpclic = Request.form("frmtpclicense") End If if...
  7. Reynet01

    Session Variables

    I am trying to do an insert on a database with a couple of fields being updated with Session values However everything updates but the two fields that are being supplied by the session values. If i hit refresh on the web browser It creates a new record WITH the session Values inserted into the...
  8. Reynet01

    DateTime Query

    I Know this is simple but how would I lookup records in a Datetime field that would only show me records for todays date. If knowledge were power I would be a AAA battery!
  9. Reynet01

    Date Range Query Problem!

    I know the following parameter query is probably bloated and uneccassary but it's all I know how to do to make it work. I have on Problem though the following works but the {Dictations.dtScribed}field gets updated when a job comes back from QA and it throws off the report. there is however a...
  10. Reynet01

    Embedded Field formating in text formula

    I have a field called jobnumber that shows up as a long number such as 75412.00 I would like it to only show 75412 how do I format the number if it is embedded in a text formula. Below is the formula if {Dictations.state}=14 then "At Transcriptionist" & "/" & " "&{Dictations.JobNumber}else if...
  11. Reynet01

    Time stamp calculation Queston

    I have a field with a Date/time I would like to build a lookup parameter by that field such so client can enter a number of hours and it show and record that is older than the number of hours entered, such as if the client enters 12 hours it will show all records that are 12 hours or older. Any...
  12. Reynet01

    Directory Listing for JUpload

    I am using jupload and it has static setting for the upload directory I would like to present the user with a directory listing to choose the upload directory from a drop down menu. how would I code this with the following code UPLOAD FORM PAGE: <HTML> <HEAD> <TITLE>JUpload 1.0...
  13. Reynet01

    SQL Upgrade killed my Query

    I have the following query that worked on access databse with numeric field when we upgraded to SQL the field are now int fields and my query does not work properly any more below is the recordset. any ideas on how to fix it? Set Recordset1 = Server.CreateObject("ADODB.Recordset")...
  14. Reynet01

    Do I use a case statement?

    I have posted this in the SQL Forum also but maybe some here can help I have the following query SELECT PatientProfile.PatientId, PatientProfile.First, PatientProfile.Middle, PatientProfile.Last, PatientProfile.SSN, PatientProfile.Birthdate,DoctorFacility.ListName, DoctorFacility.Phone2...
  15. Reynet01

    Case Statement?

    I have the following query SELECT PatientProfile.PatientId, PatientProfile.First, PatientProfile.Middle, PatientProfile.Last, PatientProfile.SSN, PatientProfile.Birthdate,DoctorFacility.ListName, DoctorFacility.Phone2, DoctorFacility.Phone2Type FROM PatientProfile LEFT JOIN DoctorFacility ON...

Part and Inventory Search

Back
Top