|
Home > Archive > FrontPage Server Extensions for Windows > January 2006 > Database wizard search
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Database wizard search
|
|
|
| Hi,
I am using Frontpage 2003, iis6.0 with fpse 2002 installed and i have
created a database coneection and using a form to search the database, but i
would like to use a check box in my search form to find persons who have that
specific attribute.
I use access 2003 to create the database and the check box on/off attribute
but i cannot seem to be able to pass the parameter from the search form to
the results wizard. Any ideas
Thanks
| |
| Stefan B Rusynko 2006-01-04, 7:56 am |
| In Access set your field (identifying the special attributes records - say a filed named SPECIAL) to data type Yes/No with Format as
True/false
Then set your query as
strSQL = "SELECT * FROM TABLENAME WHERE SPECIAL = TRUE"
--
________________________________________
_____
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/FrontP...53/Default.aspx
________________________________________
_____
"paulo" <paulo@discussions.microsoft.com> wrote in message news:2F663317-ABCF-4261-8AF4-66A890768CD4@microsoft.com...
| Hi,
| I am using Frontpage 2003, iis6.0 with fpse 2002 installed and i have
| created a database coneection and using a form to search the database, but i
| would like to use a check box in my search form to find persons who have that
| specific attribute.
| I use access 2003 to create the database and the check box on/off attribute
| but i cannot seem to be able to pass the parameter from the search form to
| the results wizard. Any ideas
| Thanks
|
|
| |
|
| Hi,
Thanks for that, now i only have to workout how to search with multiple
check boxes
Regards
"Stefan B Rusynko" wrote:
> In Access set your field (identifying the special attributes records - say a filed named SPECIAL) to data type Yes/No with Format as
> True/false
>
> Then set your query as
> strSQL = "SELECT * FROM TABLENAME WHERE SPECIAL = TRUE"
> --
>
> ________________________________________
_____
> 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/FrontP...53/Default.aspx
> ________________________________________
_____
>
>
> "paulo" <paulo@discussions.microsoft.com> wrote in message news:2F663317-ABCF-4261-8AF4-66A890768CD4@microsoft.com...
> | Hi,
> | I am using Frontpage 2003, iis6.0 with fpse 2002 installed and i have
> | created a database coneection and using a form to search the database, but i
> | would like to use a check box in my search form to find persons who have that
> | specific attribute.
> | I use access 2003 to create the database and the check box on/off attribute
> | but i cannot seem to be able to pass the parameter from the search form to
> | the results wizard. Any ideas
> | Thanks
> |
> |
>
>
>
| |
| Stefan B Rusynko 2006-01-05, 7:56 am |
| Depends
- if you want an AND or an OR search
--
________________________________________
_____
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/FrontP...53/Default.aspx
________________________________________
_____
"paulo" <paulo@discussions.microsoft.com> wrote in message news:C3CA29F8-E35F-428D-B8DD-DF4E247DD143@microsoft.com...
| Hi,
| Thanks for that, now i only have to workout how to search with multiple
| check boxes
| Regards
|
|
|
| "Stefan B Rusynko" wrote:
|
| > In Access set your field (identifying the special attributes records - say a filed named SPECIAL) to data type Yes/No with
Format as
| > True/false
| >
| > Then set your query as
| > strSQL = "SELECT * FROM TABLENAME WHERE SPECIAL = TRUE"
| > --
| >
| > ________________________________________
_____
| > 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/FrontP...53/Default.aspx
| > ________________________________________
_____
| >
| >
| > "paulo" <paulo@discussions.microsoft.com> wrote in message news:2F663317-ABCF-4261-8AF4-66A890768CD4@microsoft.com...
| > | Hi,
| > | I am using Frontpage 2003, iis6.0 with fpse 2002 installed and i have
| > | created a database coneection and using a form to search the database, but i
| > | would like to use a check box in my search form to find persons who have that
| > | specific attribute.
| > | I use access 2003 to create the database and the check box on/off attribute
| > | but i cannot seem to be able to pass the parameter from the search form to
| > | the results wizard. Any ideas
| > | Thanks
| > |
| > |
| >
| >
| >
| |
|
| Both unfortunately, i have written this code to search. SELECT * FROM
Formsslt WHERE (london = ::london:: AND north_east = ::north_east:: AND
north_west = ::north_west:: AND home_counties = ::home_counties:: AND
midlands = ::midlands:: AND south_west = ::south_west:: AND wales = ::wales::
AND scotland = ::scotland:: AND east_anglia = ::east_anglia: . If change the
AND to OR I get all records returned when i check every box
Regards
"Stefan B Rusynko" wrote:
> Depends
> - if you want an AND or an OR search
>
> --
>
> ________________________________________
_____
> 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/FrontP...53/Default.aspx
> ________________________________________
_____
>
>
> "paulo" <paulo@discussions.microsoft.com> wrote in message news:C3CA29F8-E35F-428D-B8DD-DF4E247DD143@microsoft.com...
> | Hi,
> | Thanks for that, now i only have to workout how to search with multiple
> | check boxes
> | Regards
> |
> |
> |
> | "Stefan B Rusynko" wrote:
> |
> | > In Access set your field (identifying the special attributes records - say a filed named SPECIAL) to data type Yes/No with
> Format as
> | > True/false
> | >
> | > Then set your query as
> | > strSQL = "SELECT * FROM TABLENAME WHERE SPECIAL = TRUE"
> | > --
> | >
> | > ________________________________________
_____
> | > 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/FrontP...53/Default.aspx
> | > ________________________________________
_____
> | >
> | >
> | > "paulo" <paulo@discussions.microsoft.com> wrote in message news:2F663317-ABCF-4261-8AF4-66A890768CD4@microsoft.com...
> | > | Hi,
> | > | I am using Frontpage 2003, iis6.0 with fpse 2002 installed and i have
> | > | created a database coneection and using a form to search the database, but i
> | > | would like to use a check box in my search form to find persons who have that
> | > | specific attribute.
> | > | I use access 2003 to create the database and the check box on/off attribute
> | > | but i cannot seem to be able to pass the parameter from the search form to
> | > | the results wizard. Any ideas
> | > | Thanks
> | > |
> | > |
> | >
> | >
> | >
>
>
>
| |
|
| Redesign the database so that you have a single column for the Area -
a record can only be in one area, not several (unless your application
is different from the norm). The Area column contains the name of the
area associated with the record.
The SQL then becomes:
SELECT * FROM Formsslt WHERE (Area = "::london::" OR Area ="
::north_east::" OR
Area =" ::north_west::" OR Area =" ::home_counties::" OR Area =
"::midlands::" OR Area = "::south_west::" OR Area = "::wales::" OR
Area = "::scotland::" OR Area = "::east_anglia::").
Note that the fields need to be quoted, since they are not numeric
values.
A typical checkbox is then coded as
<input type="checkbox" value="East Anglia" name="east_anglia">
--
Ron Symonds - Microsoft MVP (FrontPage)
Reply only to group - emails will be deleted unread.
FrontPage Support: http://www.frontpagemvps.com/
"paulo" <paulo@discussions.microsoft.com> wrote in message
news:2DD2B328-5DC6-4AF2-8CDA-47CD4CA9A168@microsoft.com...
> Both unfortunately, i have written this code to search. SELECT *
FROM
> Formsslt WHERE (london = ::london:: AND north_east = ::north_east::
AND
> north_west = ::north_west:: AND home_counties = ::home_counties::
AND
> midlands = ::midlands:: AND south_west = ::south_west:: AND wales =
::wales::
> AND scotland = ::scotland:: AND east_anglia = ::east_anglia:. If
change the[vbcol=seagreen]
> AND to OR I get all records returned when i check every box
> Regards
>
>
>
>
>
> "Stefan B Rusynko" wrote:
>
http://www.frontpagemvps.com/FrontP...53/Default.aspx[vbcol=seagreen]
news:C3CA29F8-E35F-428D-B8DD-DF4E247DD143@microsoft.com...[vbcol=seagreen]
with multiple[vbcol=seagreen]
records - say a filed named SPECIAL) to data type Yes/No with[vbcol=seagreen]
http://www.frontpagemvps.com/FrontP...53/Default.aspx[vbcol=seagreen]
news:2F663317-ABCF-4261-8AF4-66A890768CD4@microsoft.com...[vbcol=seagreen]
and i have[vbcol=seagreen]
database, but i[vbcol=seagreen]
persons who have that[vbcol=seagreen]
on/off attribute[vbcol=seagreen]
search form to[vbcol=seagreen]
| |
|
| Thanks for that
"Ronx" wrote:
> Redesign the database so that you have a single column for the Area -
> a record can only be in one area, not several (unless your application
> is different from the norm). The Area column contains the name of the
> area associated with the record.
>
> The SQL then becomes:
> SELECT * FROM Formsslt WHERE (Area = "::london::" OR Area ="
> ::north_east::" OR
> Area =" ::north_west::" OR Area =" ::home_counties::" OR Area =
> "::midlands::" OR Area = "::south_west::" OR Area = "::wales::" OR
> Area = "::scotland::" OR Area = "::east_anglia::").
>
> Note that the fields need to be quoted, since they are not numeric
> values.
> A typical checkbox is then coded as
>
> <input type="checkbox" value="East Anglia" name="east_anglia">
>
> --
> Ron Symonds - Microsoft MVP (FrontPage)
> Reply only to group - emails will be deleted unread.
> FrontPage Support: http://www.frontpagemvps.com/
>
>
> "paulo" <paulo@discussions.microsoft.com> wrote in message
> news:2DD2B328-5DC6-4AF2-8CDA-47CD4CA9A168@microsoft.com...
> FROM
> AND
> AND
> ::wales::
> change the
> http://www.frontpagemvps.com/FrontP...53/Default.aspx
> news:C3CA29F8-E35F-428D-B8DD-DF4E247DD143@microsoft.com...
> with multiple
> records - say a filed named SPECIAL) to data type Yes/No with
> http://www.frontpagemvps.com/FrontP...53/Default.aspx
> news:2F663317-ABCF-4261-8AF4-66A890768CD4@microsoft.com...
> and i have
> database, but i
> persons who have that
> on/off attribute
> search form to
>
>
>
|
|
|
|
|