Best Practice: Databases: Querys in DB or WebPage

[SUnderwood]

Hi

In breif, where is the best place to store a query definition when creating a DB driven web based application, in the web-pages through DW's database tools or in the database itself? (The database platform I will be using is Access, but in general I would believe the same rules should apply to all DBs)


Regards

Sean

PS I have posted this same question in the deamweaver list but have received no response from the web experts (where are they all?)

 

[psemianonymous]

Just shooting from the hip I'd recommend you use SQL statements, thus affording a *little* more portability. Access/JET SQL isn't standard, but if you ever had to move to another DB type, the SQL is easier to convert than the query names. This also helps for quickfixes (oops! I forgot field X).

But this is all with *cough* limited web experience.