var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: using parenthesis
This must be so simple to you guys, but I have to ask it.
I want to select data base on several criteria. I am using Cold Fusion, but the SQL should be the same, so I am asking it here.
My query looks like this:
<!-- check to see if both bandname AND emailaddress is present BUT NOT verified -->
<cfquery name="bandname_and_emailaddress_present_NOT_VERIFI ED" datasource="lmd" dbtype="ODBC">
SELECT bandid, bandname,password1, emailaddress FROM band WHERE (emailaddress = '#form.emailaddress#') AND (bandname = '#form.bandname#') and (verified = '')
So, firstly, how can I select all records that have the form.emailaddress and form.bandname and verified has no data in it.
(Verified is a column that gets a 'y' when someone responds to an email and enters the correct password.
Just so I understand this topic, can someone explain the basics of using parenthesis. Thanking you in advance.
Re: using parenthesis
I figured out the answer.
SELECT bandid, bandname,password1, emailaddress FROM band WHERE emailaddress = '#form.emailaddress#' AND bandname = '#form.bandname#' and verified is null
Please ignore my question and help other lost souls.