Dreamweaver - Database Driven Query

Author

Database Driven Query

Simon R

2004-08-10, 11:16 pm

Thanks Guys,
Ive re posted this in the hope you can help, Well here's where im up to and
it seems that this thing cant handle 2 recordsets on the same page, thats
not right is it?:

* I created a seperate comment table (with fields such as:
commentID(autonumber), imageID and comment))

*on the results page i created a second recordset, so now there is the image
recordset and the comment record set.

*on the comment recordset i tried to use dreamweavers simple SQL which
basically was [imageID] [=] [URL Parameter] [ID]

When i tested it using the default value for the ID it worked fine, but when
i uploaded and tested... errror :(

I also used the advanced setting and typed in Angela's code which was:

Select *
FROM Mobpic, Comments
WHERE ID = imageID

and this seemed to list all the fields when tested, but when uploaded...
ERROR!

Hope you can shed somemore light as I feel that i'm pretty close now :)

Simon

"~Angela, TMM" <angela@ILOVESNIPPETSdwfaq.com> wrote in message
news:cebvl5$rhd$1@forums.macromedia.com...
> Hello Simon,
>
> right
>
> Great, and you're welcome.
>
> what
know?[color=darkred]
>
> This wouldn't be built in anywhere...However, you could use Dreamweaver's
> tools to help you build a query.
>
> Not sure if what Les Matthews posted is enough for you to follow, so I'll
> try to explain further. Hopefully it doesn't confuse things for you!
>
> I will assume that you're storing the name of the file in the database,
> correct? Each file name belongs within a different row in the table. That
> row should have an autonumber field for the imageDescriptionID. I named it
> that in my previous example, but you could have named it, imageID or
> imageRecordID or iLoveSQLandDreamweaverID (however, I recommend using
names
> that are applicable to what you're doing that makes sense ;-)). In other
> words, you'd use that record's ID for the relationship. In the table that
> holds all the comments, for each comment you would store the image's ID.
>
> Then you would do the query as I described in my previous message.
>
> Hope that clarifies things for you some, but if not do let us know and
I'll
> try to help.
>
> Good luck,
> ~Angela
> --
> Angela C. Buraglia, Founder:
> ~FAQs, Tutorials & Resources~ http://www.DreamweaverFAQ.com
> ~My Extensions~ http://www.dwfaq.com/go.asp?ID=AngelaX10
> DWfaq Support Newsgroup: news://support.dwfaq.com/support
>
> Co-Author with Joseph Lowery, Dreamweaver MX 2004 Killer Tips:
> http://www.dwkillertips.com
>
> Extension Developer for Cartweaver 2:
> http://www.cartweaver.com/features/extensionsuite/
>
> Remove the CAPS in my E-mail to reply off list.
>
>
> for
blog[color=darkred]
server[color=darkred]
subscribing[color=darkred]
> populate
field[color=darkred]
> database.
server[color=darkred]
> the
about[color=darkred]
> comments
that[color=darkred]
because[color=darkred]
>
>

Simon R

2004-08-10, 11:17 pm

Ive sorted this now.. it was a permissions problep :)

Simon

"Simon R" <simon.ramsden@zen.co.uk> wrote in message
news:4118eeb3$0$204$db0fefd9@news.zen.co.uk...
> Thanks Guys,
> Ive re posted this in the hope you can help, Well here's where im up to
and
> it seems that this thing cant handle 2 recordsets on the same page, thats
> not right is it?:
>
> * I created a seperate comment table (with fields such as:
> commentID(autonumber), imageID and comment))
>
> *on the results page i created a second recordset, so now there is the
image
> recordset and the comment record set.
>
> *on the comment recordset i tried to use dreamweavers simple SQL which
> basically was [imageID] [=] [URL Parameter] [ID]
>
> When i tested it using the default value for the ID it worked fine, but
when
> i uploaded and tested... errror :(
>
> I also used the advanced setting and typed in Angela's code which was:
>
> Select *
> FROM Mobpic, Comments
> WHERE ID = imageID
>
> and this seemed to list all the fields when tested, but when uploaded...
> ERROR!
>
> Hope you can shed somemore light as I feel that i'm pretty close now :)
>
> Simon
>
>
>
> "~Angela, TMM" <angela@ILOVESNIPPETSdwfaq.com> wrote in message
> news:cebvl5$rhd$1@forums.macromedia.com...
I'm[color=darkred]
> know?
Dreamweaver's[color=darkred]
I'll[color=darkred]
That[color=darkred]
it[color=darkred]
> names
that[color=darkred]
> I'll
series[color=darkred]
that[color=darkred]
> blog
> server
> subscribing
> field
WHERE[color=darkred]
> server
on[color=darkred]
> about
a[color=darkred]
> that
> because
>
>
>
>

Simon R

2004-08-13, 12:16 pm