Custom Queries

[Irwin Fletcher]

I have a number of different custom queries that I need to do on an SQL
Server database. I'm doing a custom query because it appears that the
UI can't do what I need (I need to do some JOINS). For the life of me,
I can't get the syntax right in the custom query window.

Can someone point me to some documentation or give me some hints on the
correct syntax for this window? Or if there is another preferred way to
do "complicated" queries in Front Page, can someone give me a shove in
the right direction?

 

[Stefan B Rusynko]

You will need to learn hand coded ASP and not rely in the wizards
- some workarounds for using the wizards are at http://home.att.net/~codelibrary/FrontPage/index.html

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I have a number of different custom queries that I need to do on an SQL
| Server database. I'm doing a custom query because it appears that the
| UI can't do what I need (I need to do some JOINS). For the life of me,
| I can't get the syntax right in the custom query window.
|
| Can someone point me to some documentation or give me some hints on the
| correct syntax for this window? Or if there is another preferred way to
| do "complicated" queries in Front Page, can someone give me a shove in
| the right direction?

 

[Irwin Fletcher]

Let's say I wanted to do a simple SQL query using the custom query
window (let's say select a from b where col1=hello). I can't even make
that work. There must be some syntax that does work. Anyone ever used
this or have any ideas on where to find documentation?

 

[Thomas A. Rowe]

Fieldname is a String format:
Select * from tablename where fieldname = '" & Request.Form("lookup") & "' "

Fieldname is Numeric format:
Select * from tablename where fieldname = " & Request.Form("lookup")

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================