Thanks Scott,
That's exactly what I was looking for.
-Cornelius
on 12/20/02 9:45 AM, Scott Cadillac at [EMAIL PROTECTED]
wrote:
> Sorry,
>
> I think I missed a double-quote on of the STR= attributes :-P
>
> Cheers...
>
> ----- Original Message -----
> From: "Scott Cadillac" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, December 20, 2002 10:41 AM
> Subject: Re: Witango-Talk: wrapping XML tags around output
>
>
>> Hi Cornelius,
>>
>> I guess this might be better suited to SQL or <@REPLACE>
>>
>> If I understand what you are saying, that if your database query
> potentially
>> returns one of the columns with some <a href="...">...</a> text, you could
>> get the SQL statement to wrap the column with the extra XML text like so:
>>
>> (use Direct_DBMS)
>>
>> SELECT field_one,
>> field_two,
>> '<article.object type="url">' + field_three +
>> '</article.object>' AS field_three
>> FROM some_table
>>
>> This will populate the third column of your local$resultset array with the
>> extra XML text wrapped around the field value.
>>
>> But, if I'm not understanding you, and the database field contains other
>> HTML text as well as <a></a>, then you might have to loop through your
> array
>> a
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
