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!

Recent content by vehto

  1. vehto

    php value='00-0123'

    Yes I ampassing the value to mysql mysql_query ("insert into testdb (user_id, act_id) values ($user '$act')") WOW its working !! Thanks sleipnir
  2. vehto

    php value='00-0123'

    Help newbie I have a PHP script with a dash in a value field Problem: mysql is interpeting the dash (-) as a minus sign can anyone help with this ??
    • vehto
    • Thread
    • Replies: 3
    • Forum: PHP
  3. vehto

    format example

    newbie Im having a format problems Im hacking someone else's script what does this do ? I understand the varibles but I do not know what the "position" statement means begin-progam #define OCODE_COL 1 #define OPER_COL 10 begin-select a.oper_id &oper position (+1,1) print...
  4. vehto

    SYSDATE

    Excellent That did the trick !! Thanks for your help SantaMufasa !
  5. vehto

    SYSDATE

    Question: simple maybe ? I would like too query data for the past 7 days using sysdate where To_CHAR (Collect_dt 'MM/DD/YYYY' = To_CHAR(sysdate ? 'MM/DD/YYYY') sysdate-7 returns only data for one day Thanks vehto
  6. vehto

    help... out of options with union

    YES! Thanks you ! this is what Im trying to do Turkbear All text was returned with the query for the loc_code but the seq_num and associated text or out of order another problem I encountered. (ctl_date '18-aug-03' is correct my goof) Example: 123 text...... 123 text..... 333 text ...
  7. vehto

    help... out of options with union

    can any one help ? newbie I have three table's two have text need. select text_x from table_x where ctl_date> '18-aug03' and seq_num = '123' union all select text_y from table_y where ctl_date> '18-aug03' and seq_num = '123'; This works! and returns the text I need now I need to incoporate...
See more

Part and Inventory Search

Back
Top