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 Wanet Telecoms Ltd 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: ixnay5
  • Order by date
  1. ixnay5

    radio button reset not working

    thx cLFlaVA.
  2. ixnay5

    radio button reset not working

    hi - i have a reset button with an onclickto reset some radio buttons. the radio buttons will not reset, but the other lines in the reset function definition execute correctly. what the heck am i doing wrong? here's the html for the reset button: <input type="button" name="fromresetbutton"...
  3. ixnay5

    why is this happening?

    p.s. if you live in the San Diego area, i'd like to buy you a beer! thanks again for all your help!
  4. ixnay5

    why is this happening?

    hey ed, looks like it's working. besides than building the variable string the way you've suggested all along, the only other thing done differently was to define the variables as varchar, like this: define myord varchar(10) define mysono varchar(10) build up the variable...
  5. ixnay5

    why is this happening?

    ...display myord insert into tmpship select indoc,apart,inlots,cpart,serln from inbos where indoc matches "*myord*" but the wildcard match still isn't happening. the informix 7.x reference manuals and cathy kipp's book (Programming Informix SQL/4GL A Step...
  6. ixnay5

    why is this happening?

    thanks again ed, the compile error has gone away, but building the matches string as prescribed just the literal string "*sono*" into the myord variable, not the value.
  7. ixnay5

    why is this happening?

    ...sono) from sonos" prepare ex_o from o declare o_curs cursor for ex_o display "Selecting Top Part and Serial Data..." foreach o_curs into ord.* display ord.sono let myord = "" let myord = ord.sono #doesn't work insert into tmpship select...
  8. ixnay5

    why is this happening?

    myord is defined as: define myord char(10)
  9. ixnay5

    why is this happening?

    thx ed. i can tell you this. if i remove these lines: let myord = "" let myord = ord.sono the line immediately above them: display ord.sono ...successfully displays the value of ord.sono at run time, telling me that table sonos gets good data. i don't understand...
  10. ixnay5

    why is this happening?

    ...load tmpship table let o = "select trim(leading from sono) from sonos" prepare ex_o from o declare o_curs cursor for ex_o foreach o_curs into ord.* display ord.sono let myord = "" let myord = ord.sono |_______________________^ | | A grammatical error has been...
  11. ixnay5

    using a 4gl variable in a sql &quot;like&quot; statement

    thx ed. i found out you can build it into a cursor statement and it will work. but if try to use it in a SQL statement contained in a foreach cursor loop, it won't. still having trouble doing wildcard matches in SQL statements in foreach cursor loops tho... thanks again for all your help!
  12. ixnay5

    using a 4gl variable in a sql &quot;like&quot; statement

    thx ed. i tried that and some other variations with no luck. turns out the value i'm feeding into the variable is coming out of the table with some leading spaces which need to be removed. it's char(10) but we're storing values with 6 or 8 meaningful chars. i thought CLIPPED would take care...
  13. ixnay5

    using a 4gl variable in a sql &quot;like&quot; statement

    ...indoc char(10), apart char(16), inlots char(18), cpart char(16), serln char(18) end record --...setup the cursor foreach d_curs into dat.* select distinct fssitecd,sotadat into site,sdate from fssps where fssps.sono like dat.indoc --...do some stuff end...
  14. ixnay5

    using a 4gl variable in a sql &quot;like&quot; statement

    hi - is there special syntax for handling a wildcard search if the value i'm matching on is a 4gl variable? the basic statement is: select something from somewhere where something like my.value something could be a large field and my.value could be anywhere in it. so i tried: select...
  15. ixnay5

    validate numeric

    i just pulled the isNAN(q) from the function and put this: function tst_qty(fieldobj) { //if the value entered isn't acceptable, bail out var v = parseFloat(fieldobj.value); if (isNaN(v)) { errors = "Please enter a number"; alert(errors); return false; } return true; } as an...
  16. ixnay5

    validate numeric

    well for one thing, "(isblank(q))" makes no sense. still trying...
  17. ixnay5

    validate numeric

    hi - trying to simply validate a text box entry (fieldname: qty) on form submit. if it's not numeric, throw an alert. but of course it isn't working and i can't see why. it's throwing the alert whether the entry is valid or not. here's the code: (ignore pcount and scount...they're always...
  18. ixnay5

    why doesn't this reset my form?

    khat. that was the problem. thanks for spotting it.
  19. ixnay5

    why doesn't this reset my form?

    adam0101: long story involving another thread. prob. the less said about it the better, but here goes: i was trying to write a simple function that i could put in <body onload=""> so that if i couldn't get the dynamic divs i'm using to redisplay when the user hits the back button, at least i...
  20. ixnay5

    make div visible after submit and back button

    prev. message continued. nevermind the last sentence (fragment)...

Part and Inventory Search

Back
Top