Recent content by BadSector

  1. B

    Access last created record

    Thanks for the reply! My problem wasn't passing the # of the last created record to the next procedure ( shared variables work fine ) but rather the "FIND" bit. It seems that there isn't enough time between a CREATE and FIND for the last record to be commited to the DB. (I think, no, I know...
  2. B

    Access last created record

    Hi, I have : assignValues.html define new shared variable tempreqnum like bytesbrd.reqnum. create BytesBRD. Assign ReqNum = tempreqnum. /*tempreqnum increments Assign Benefits = get-value("Benefit"). Assign BRDReceived = "NO". . . RUN value("sendEmail.html"). sendEmail.html define...
  3. B

    Redirect in Speedscript

    OK - I've used a quick and dirty workaround: autorefresh with a check to see if ReqBy has been entered. The refresh seems to flush POST variables, taking ReqBy back to it's default value. IF REQUEST_METHOD = "POST":U and get-value("ReqBy")<> "Enter Name" THEN DO: create BytesBRD. Assign...
  4. B

    Redirect in Speedscript

    I found : http://www.progresstalk.com/showthread.php?t=93436&highlight=header which might/ might not be the answer. Is the RUN run-web-object (INPUT "main.p"). Escript talks about the same as the HTTP redirect header set he mentions? I need to be able to call another HTML file.
  5. B

    Redirect in Speedscript

    Hi Is there an equivalent to PHP's header command to redirect to another page? I have an online form that uses POST to post to itself i.e. the processing is done in the same form. I want to seperate the processing from the form to avoid issues like reposting when refreshing etc. I know...
  6. B

    BY expression

    Thanks Tom! Went with the case. WORKED PERFECTLY. I tried the include approach but it didn't seem to work. I'm not sure the include was a valid solution, I passed it the variable but still had no luck. From memory, I tried : main prog {include.i &sortby=sortby} include.i OPEN QUERY...
  7. B

    BY expression

    Thanks for your quick reply, vigneshbr! Is using an include the only way? It seems longwinded for a feature that seems elementary. I could make a procedure for every possible value of sortby - but that be repetitive.
  8. B

    BY expression

    Hi All, Total newbie, so please be kind. def var sortby as char. sortby is set in a form. (EG. id, name, date, group etc) I output sortby and can confirm that it is correctly set. OPEN QUERY brdquery FOR EACH brd BY sortby. As you can see I need the value in sortby resolved to a...
Top