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!

Search results for query: *

  • Users: jojo79
  • Content: Threads
  • 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

    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...
  3. 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.
  4. 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...
  5. 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 (...
  6. 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];
  7. 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...
  8. 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
  9. 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...
  10. 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...
  11. 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...
  12. 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"
  13. 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...
  14. 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...
  15. 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...
  16. 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.
  17. jojo79

    Trigger?? or some-other way....

    I need help on a trigger that will update a tables value if the skew number is exists, if not, add it to the table. My information is below, I have tried many triggers, but all without results I am looking for. I just need a little help thinking outside the box. tbl_inv skew(nvarchar)...
  18. jojo79

    SQL Inventory System

    I have to create an inventory warehouse system. I already have the main tables done, What I need is a couple transaction tables and maybe a current inventory table. I also think Triggers will be needed. What it needs to contain and do is the following: > Basic Warehouse system > Maintain...
  19. jojo79

    Open new tab(IE7), instead of new window

    Does anyone know or have any information regarding opening a new tab rather then a new window.???
  20. jojo79

    IS NULL not working in Case Statement

    I am trying to run the following case command and I am coming up with an error. Something I am doing wrong. case CONVERT(varchar(20),datediff(dd,VOUCHERED, [CK DATE])) when 0 then 'Same Day' when 1 then 'Next Day' when IS NULL then 'Check not cut' else...

Part and Inventory Search

Back
Top