filtering recordset

[WebSlave]

I am trying to pull a recordset that has the following items: ID Name
Description Image1 Image2 Image3 DateAdded Is there anyway that I could pull
fhe following into my SQL?: ID Name Description
[url]http://www.url.com/inventory/image1[/url] [url]http://www.url.com/inventory/image2[/url]
[url]http://www.url.com/inventory/image3[/url] DateAdded Adding the url to the photos? I
know the exact URL for each. Using ASP, MSAccess, SQL

[Nancy Gill]

How are your tables set up? You can easily do this .. but I can't give you
an example of what the SQL would look like without knowing the table
structure you have set up.

I'm assuming you would display something about all records and then link to
a detail page that would show all the info you sited about a particular
record. Something like SELECT Name, Description Image1, Image2, Image3,
Date Added (or SELECT * if this is everything in the table) where ID =
MMColParam .. and then set MMColParam equal to the URL parameter of ID in
the variables.

Something like that?

--
Nancy Gill
Team Macromedia Volunteer for Dreamweaver MX/UltraDev
[url]http://www.macromedia.com/go/team/[/url]
Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A Beginner's
Guide, Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"WebSlave" <webforumsuser@macromedia.com> wrote in message
news:d21bhh$g2r$1@forums.macromedia.com...

> I am trying to pull a recordset that has the following items: ID Name
> Description Image1 Image2 Image3 DateAdded Is there anyway that I could

pull

> fhe following into my SQL?: ID Name Description
> [url]http://www.url.com/inventory/image1[/url] [url]http://www.url.com/inventory/image2[/url]
> [url]http://www.url.com/inventory/image3[/url] DateAdded Adding the url to the

photos? I

> know the exact URL for each. Using ASP, MSAccess, SQL
>

[BillB]

Nancy, when is your site coming pack online??


--
Bill
Real Estate Web Sites Made Easy
[url]www.DataPacks.com[/url]


"Nancy Gill" <nancy@webwish.com> wrote in message
news:d21cab$h2t$1@forums.macromedia.com...

> How are your tables set up? You can easily do this .. but I can't give
> you
> an example of what the SQL would look like without knowing the table
> structure you have set up.
>
> I'm assuming you would display something about all records and then link
> to
> a detail page that would show all the info you sited about a particular
> record. Something like SELECT Name, Description Image1, Image2, Image3,
> Date Added (or SELECT * if this is everything in the table) where ID =
> MMColParam .. and then set MMColParam equal to the URL parameter of ID in
> the variables.
>
> Something like that?
>
> --
> Nancy Gill
> Team Macromedia Volunteer for Dreamweaver MX/UltraDev
> [url]http://www.macromedia.com/go/team/[/url]
> Co-Author: Dreamweaver MX: Instant Troubleshooter (August, 2003)
> Technical Editor: DMX 2004: The Complete Reference, DMX 2004: A
> Beginner's
> Guide, Mastering Macromedia Contribute
> Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web
> Development
>
> "WebSlave" <webforumsuser@macromedia.com> wrote in message
> news:d21bhh$g2r$1@forums.macromedia.com...

>> I am trying to pull a recordset that has the following items: ID Name
>> Description Image1 Image2 Image3 DateAdded Is there anyway that I could

> pull

>> fhe following into my SQL?: ID Name Description
>> [url]http://www.url.com/inventory/image1[/url] [url]http://www.url.com/inventory/image2[/url]
>> [url]http://www.url.com/inventory/image3[/url] DateAdded Adding the url to the

> photos? I

>> know the exact URL for each. Using ASP, MSAccess, SQL
>>

>
>

[WebSlave]

All of these items are in the same table, in this order.

My end goal is to be able to pull the items down to a csv file for upload to another site.

Any advice?