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!

  • 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: vehto
  • Content: Threads
  • Order by date
  1. 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 ??
  2. 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...
  3. 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
  4. 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...

Part and Inventory Search

Back
Top