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!

Search results for query: *

  • Users: jimny
  • Order by date
  1. jimny

    order by clause acting funny

    thanks SQLBill will attempt...
  2. jimny

    order by clause acting funny

    I have a cloumn nDays type nVarchar(50)in a table some entries are like "1 & 2" and some are single numbers like "12" or "1". If I execute "SELECT news.nDays FROM News ORDER BY nDays" it orders the results by the leading digit. For example, five rows...
  3. jimny

    Boolean result from SQL Update for asp page

    thanks Veep, haven't been able to get it running, but am in the right neighborhood
  4. jimny

    Boolean result from SQL Update for asp page

    OOPs sorry coding two different thoughts in one post. CREATE Procedure InsertNum @Num int(4) @RetVal As Update tblNum set num = '@Num' return @@Error as RetVal GO -- OR -- CREATE Procedure InsertNum @Num int(4) As Update tblNum set num = '@Num' return @@Error GO
  5. jimny

    Boolean result from SQL Update for asp page

    If what i am talking about is a return value, then how do I retrieve said value? CREATE Procedure InsertNum @Num int(4) As Update tblNum set num = '@Num' return @@Error GO ????
  6. jimny

    Boolean result from SQL Update for asp page

    I know that a sql functin should return a value of -1,0 or 1, but I have no been able to use it to validate whether a process has completed syuccessfully. Example: sql = "UPDATE tblNum t WHERE t.num = '"&num&"'" verify = conn.execute(sql) -- OR preferably-- is there a...
  7. jimny

    Regular Expression for phone number

    clarkin, My bad, You are correct, it is only matching once. had a line that I thought I commented out for display but had not. Once again thanks for the thorough response.
  8. jimny

    Regular Expression for phone number

    Never Mind...Figured it out. now if I can only set it to match once... Thanks again!!
  9. jimny

    Regular Expression for phone number

    clarkin, thanks for the thorough and rapid response... When implementing the above code, When I loop through the "For each submatch in match.submatches" it displays the 3 submatches beautifully, but when I access the object matchesColl(0) and its' property submatches...
  10. jimny

    Regular Expression for phone number

    I am trying to extract a phone number from a text string, display the first part of string before the phone number, then the second part, then the phone number. I am first splitting the the string: text = cstr(rsAd("adtext")) aryTxt = split(text," ") then am looping to find...
  11. jimny

    Newbie needs help with QueryString

    Thanks for the quick response. I checked &quot;artist_frame.shtml&quot; and it contains a redirect(?) <!--#exec cgi=&quot;/cgi/artist_frame.php&quot;--> I tried changing the HREF to &quot;artist_frame.php&quot; and got a &quot;page cannot be found&quot; error. How would I capture the id...
  12. jimny

    Newbie needs help with QueryString

    I inherited a PERl/PHP(and I am not familiar with) site and am getting an error when looking for a querystring value. the original HREF is like: <A class=listLink href=&quot;artist_frame.shtml?artist_id=10&quot; target=cag_content>Artist 10</A> and the code on the recieving page is...
    • jimny
    • Thread
    • Replies: 2
    • Forum: PHP
  13. jimny

    Newbie needs help with QueryString

    I inherited a PERl/PHP(and I am not familiar with) site and am getting an error when looking for a querystring value. the original HREF is like: <A class=listLink href=&quot;artist_frame.shtml?artist_id=10&quot; target=cag_content>Artist 10</A> and the code on the recieving page is: $id =...
    • jimny
    • Thread
    • Replies: 1
    • Forum: Perl
  14. jimny

    If then else not processing...

    and thank you James for the clarification and response to part 2
  15. jimny

    If then else not processing...

    thanx claireHsu that was expedicious
  16. jimny

    If then else not processing...

    I have the following code... IF EXISTS (SELECT Address.AD_ID FROM Address WHERE Addr_ID = '319' AND AD_ID = '1') THEN UPDATE Address SET Street = 'Street1',City = 'City1',ST = 'ST1',ZIP = 'ZIP1',Phone = 'Phone1' WHERE Addr_ID = '319' and Ad_ID = '1'; ELSE INSERT INTO...
  17. jimny

    Carriage Return/Line Feed

    thanks for the reply but... program is unknown guesstimate SQL or foxPro thanx J. Kusch
  18. jimny

    Carriage Return/Line Feed

    I am interfacing with a program that returns data in a textfile. I am able to enter a query in the format of {tablename.field}^{tablename.field}|. I am trying to automate the process using DTS but I get a prompt that it(DTS) can not find the row delimiter (|), but if I click through and...
  19. jimny

    Using CONVERT for Varchar to Money

    I am doing an insert on an ASP page, and not able to insert a value in to a column with a datatype of 'Money'. I have tried several different ways of doing it, but get the same result with all. Here is the ASP part of geting the variable value: ResCost = request(&quot;Reservation_Cost&quot;)...
  20. jimny

    Page getting hung in Netscape

    Thank you gents, used both suggestions and have it up and running in NS6, but have issues in 4.7 What can you do? Thank you both!!!

Part and Inventory Search

Back
Top