Search results for query: *

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

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

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

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

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

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