Recent content by jimny

thanks SQLBill will attempt...

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...

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

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

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 ????

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...

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.

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

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...

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...

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...

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...

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 =...

and thank you James for the clarification and response to part 2

thanx claireHsu that was expedicious