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 dencom 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 jojo79

  1. jojo79

    asp page trying display xml

    Does anyone see anything wrong with this? I can not get anything to display. Any help would be great or some sort of direction. Thank You <html> <head> <title>Untitled Document</title> </head> <body> <% response.expires=-1 q=request.querystring("q") set...
  2. jojo79

    Trying 2 Convert 0833 to time...Im Getting an Error

    Don't really understand what you did?? It worked, but can you explain a little more??? Also will this work if it is 1033? Thanks again.
  3. jojo79

    Trying 2 Convert 0833 to time...Im Getting an Error

    Not Working: convert(varchar, convert(datetime, [Time]), 109) AS "Formatted Int" Error: Msg 242, Level 16, State 3, Line 1 The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. Anybody have any reason????? or Thoughts... I am looking for and...
  4. jojo79

    The ltrim function requires 1 arguments

    only 1 problem with the convert, In the Field, it list looks like this 000025 000041 000120 000008 LTR 000011 000045 000077 the "LTR" means it was a letter and not weighted. Can you use the case command with convert??
  5. jojo79

    The ltrim function requires 1 arguments

    trying to get rid of the leading zero's on my field Billed_Weight(nvarchar) with the following statement, with no lick select LTRIM(Billed_Weight,'0'); I get the following error The ltrim function requires 1 arguments.
  6. jojo79

    LTrim or Trim a table column down.

    I have a table called tbl_pul, I import 3000 records weekly. 1 of the columns has data that looks like this "123456789/12345". I am trying to add another column that show just to the left of the "/", so it would add a column with just "123456789". Any ideas, I think I use the LTRIM or just...
  7. jojo79

    Set default value of textbox on onclick from checkbox

    I am trying to set the value of a textbox to "transfer" if a checkbox is clicked. I have tried several ways to accomplish this with no results. Below are 2 ways that I cannot get to work. Form Name: ipc_pick Textbox Name: textbox1 Checkbox Name: check DOES NOT WORK. { if (...
  8. jojo79

    Trying to add text to javascript line

    I have the following line which returns a value. document.getElementById('qty').innerHTML = results[0]; I want to add the the word 'Total' so it will print out the word total and then the value. i have tried with no luck document.getElementById('qty').innerHTML = + 'total' + results[0];
  9. jojo79

    Seperate Results with a comma

    I have an asp page that creates a Server.CreateObject("ADODB.recordset"), What I am trying to do is have the retune value seperated by a comma. Example below. skew = request.querystring("q") sql="SELECT wh_qty,wh_skid,wh_cases FROM ipc_warehouse WHERE wh_skew= '" + skew + "'" after creating a...
  10. jojo79

    Can you seperate the xmlHttp.responseText

    Just wondering if you can separate the xmlHttp.responseText. Example, place one piece of information in one div and the other piece in another.
    • jojo79
    • Thread
    • Replies: 1
    • Forum: AJAX
  11. jojo79

    Validation...Make sure enough in stock

    SQL 2000 ASP I am trying to figure out a way to validate a textbox on a form to make sure before they submit the form or use the onChange function, I need to make sure that the number they enter, I have enough of that product in my database. Example I have 5 Apples in my tbl_stock table. Some...
  12. jojo79

    Trying to Create an .net session on .asp page

    I am trying to create a session var on an asp page, The reason is their is a link on the page that goes to a .net data-grid and it will not filter based on my .asp session. I thought you simply place the <%Session["Usr_Group"]= 2 %> in the [head], but it does not seem to work, Thanks. I was...
  13. jojo79

    Session Redirect

    I am attempting to redirect users when there session var does not equal 2. I have been having no luck with my code below, The page is an .net page. Any help would be valuable. Thanks you <%If Session("Usr_Group") != "2" then %> <script LANGUAGE='Javascript'> alert('You are being redirected to...
  14. jojo79

    Trying 2 Convert 20060703 to datetime...Im Getting an Error

    I keep getting the following error. Server: Msg 8115, Level 16, State 2, Line 3 Arithmetic overflow error converting expression to data type datetime. DECLARE @i int SELECT @i = 20060703 SELECT convert(varchar, convert(datetime, @i), 101) AS "Formatted Int"
  15. jojo79

    Transfer 1 tbl 2 another tbl +datestamp

    I am trying to figure out a SQL statement that will send all of the tables data over to another table and include a date stamp for each record. What I am doing is, I have a task setup to run a SQL statement everyday to transfer data from one table to another. Doe anyone have any ideas'. The...
See more

Part and Inventory Search

Back
Top