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 Chriss Miller 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: jojo79
  • Order by date
  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...
  16. jojo79

    Validate before form insert....

    I am trying to validate a for before it is inserted. I need it to check a table in a SQL database if a record is already inserted. Example. I insert into my table through an asp form. I enter skew_no and order_no. I need to make sure that that combo is not already in the table. Now the order...
  17. jojo79

    Percent of total Table value

    OK i got it to work, One more problem. Current Statement hat Works. str(cast(100*wh_skid/(select sum(wh_skid) from ipc_warehouse) as decimal(8,2)))+'%' It returns the following. 17% 5% 0% 0% 6% I need to see a couple more decimal places. Because the the ones that say 0% are probably 0.45%...
  18. jojo79

    Percent of total Table value

    ...convert, but that is still not working, below is what I have, I get 0's for both. Not working. cast( round( case wh_skid when 0 then 0 else 100 * convert(decimal(9,2), (wh_skid/totalskid)) end, 0 ) as int ) Not working either. select wh_skid/(select sum(wh_skid) from ipc_warehouse) from...
  19. jojo79

    Percent of total Table value

    I am a little confused in which way to handle this, I have a table called tbl_inv. It has 3 columns in it. inv_skew inv_skids inv_date I want to run a query and find out what percent of that skew is of the total value. Example: Lets just say there are 20 skews and that there are a total of 100...
  20. jojo79

    Run new Trigger on old records

    I just created a new trigger for a table, Is their a way to run the trigger on all of the previous records in the table? or should I be doing something else. the trigger is an insert trigger. It basically moves information to another table.

Part and Inventory Search

Back
Top