Marco,
I do this with one of my sites (combining fields to construct a URL),
and it works fine.
I think, possibly, including the "?ID=" in the field may be the culprit.
Try removing these characters from the field, then construct the URL as
follows:
<A href="#NewDeals.CouponURL#?ID=#NewDeals.RetailerCC#">
It's been a while since I struggled with getting it to work on my site,
but as I recall, I had problems with ".cfm" being in the field that
corresponds to your "#NewDeals.CouponURL#". When I removed the ".cfm"
from the field and placed it outside the pounds, like:
<A href="#NewDeals.CouponURL#.cfm?ID=#NewDeals.RetailerCC#">, everything
worked. If you have other file types, this might require some
conditional logic to accomplish. At the time, I didn't try
URLEncodedValue on the field. This might work, too.
--John
Marco Gil wrote:
>
> I'm using IE and it's two values. Each value is coming from the same
> database in different tables. For example:
>
> www.testing.com = First Value
> ?ID=23523626 = 2nd Value
>
> For whatever reason, when I output these two values together, it comes out
> perfect except when putting them in the HREF parameter. For whatever
> reason, it puts a "/" in between the two values like this:
>
> http://www.testing.com/ID=232626
>
> That's clearly not what I want.. i'll try out your method in a few mins :)
>
> Marco
>
> ----- Original Message -----
> From: "Rob Sherman" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, May 13, 2000 10:00 PM
> Subject: RE: Joining Two Text Fields?
>
> > > <A href="#NewDeals.CouponURL#?#NewDeals.RetailerCC#">
> >
> >
> > is it only 1 record? Or do all your entries put a "/" character there
> > between the two values?
> >
> > If it's just 1 record, then make sure you strip off the "/" from being
> > entered into the database. If all your records seem to make a "/" in the
> > browser you can try stripping off the last character:
> >
> > <A href="#left(NewDeals.CouponURL, len(NewDeals.CouponURL) -
> > 1)#?#NewDeals.RetailerCC#">
> >
> > to see if something like that would help. Also, I'm curious to know which
> > browser you are using.
> >
> > Sincerely,
> >
> > Rob Sherman
> > Developer / Allaire Certified Instructor
> > CFDude, Inc. http://www.cfdude.com
> > ------------------------------------------------------
> > Email:[EMAIL PROTECTED]
> > ICQ:_____________________________3266081
> > AIM:__________________________RobSSherm
> > Yahoo!:________________RobSherman_CFDev
> > Office:______________________(310) 543-1622
> > Office Fax:__________________(310) 543-0512
> > VMail/Fax:__________(310) 754-6016 ext. 5630
> >
> >
> > --------------------------------------------------------------------------
> ----
> > Archives: http://www.eGroups.com/list/cf-talk
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ------------------------------------------------------------------------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--
John Allred / Jackson, Mississippi
Webmaster, Mississippi Counties
http://www.mscounties.com/
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
