PC Review


Reply
Thread Tools Rate Thread

Boolean fields and SQL Database

 
 
LauraK
Guest
Posts: n/a
 
      30th Jun 2008
I have a FrontPage 2003 application form that feeds into a SQL table.
Everything works great except on my custom confirmation page where Yes/No
questions appear as True/False. Is there a way to change the confirmation
page to display Yes if the answer is True and No if it is false?

I've tried changing the code in the form using a dim statement but it isn't
working. I thought it might be easier to just change the way the field
displays on the confirmation page. Thanks!
 
Reply With Quote
 
 
 
 
Kathleen Anderson
Guest
Posts: n/a
 
      30th Jun 2008
I'm not sure what a Select statement looks like when using SQL, but could
you try something like this?

select iif(YesNoField <> 0, 'Yes', 'No') AS YesOrNo
from table


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others



"LauraK" <(E-Mail Removed)> wrote in message
news:CC2637D2-1BEC-4359-8ADB-(E-Mail Removed)...
>I have a FrontPage 2003 application form that feeds into a SQL table.
> Everything works great except on my custom confirmation page where Yes/No
> questions appear as True/False. Is there a way to change the confirmation
> page to display Yes if the answer is True and No if it is false?
>
> I've tried changing the code in the form using a dim statement but it
> isn't
> working. I thought it might be easier to just change the way the field
> displays on the confirmation page. Thanks!



 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      1st Jul 2008
Of for the field display itself
<% IF fieldname=TRUE THEN%>YES<%Else%>NO<%END IF%>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


"Kathleen Anderson" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| I'm not sure what a Select statement looks like when using SQL, but could
| you try something like this?
|
| select iif(YesNoField <> 0, 'Yes', 'No') AS YesOrNo
| from table
|
|
| --
|
| ~ Kathleen Anderson
| Microsoft MVP - FrontPage
| Spider Web Woman Designs
| Expression Web Resources: http://www.spiderwebwoman.com/xweb/
| FrontPage Resources: http://www.spiderwebwoman.com/resources/
| Please reply to the newsgroup for the benefit of others
|
|
|
| "LauraK" <(E-Mail Removed)> wrote in message
| news:CC2637D2-1BEC-4359-8ADB-(E-Mail Removed)...
| >I have a FrontPage 2003 application form that feeds into a SQL table.
| > Everything works great except on my custom confirmation page where Yes/No
| > questions appear as True/False. Is there a way to change the confirmation
| > page to display Yes if the answer is True and No if it is false?
| >
| > I've tried changing the code in the form using a dim statement but it
| > isn't
| > working. I thought it might be easier to just change the way the field
| > displays on the confirmation page. Thanks!
|
|


 
Reply With Quote
 
LauraK
Guest
Posts: n/a
 
      1st Jul 2008
Thanks Stefan, I'm not sure where to put it on the confirmation page.
FrontPage inserts <!--webbot bot="ConfirmationField" s-field="Topic1" --> for
the field. Would I include your code along with the webbot bot= or in place
of?

"Stefan B Rusynko" wrote:

> Of for the field display itself
> <% IF fieldname=TRUE THEN%>YES<%Else%>NO<%END IF%>
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "Kathleen Anderson" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> | I'm not sure what a Select statement looks like when using SQL, but could
> | you try something like this?
> |
> | select iif(YesNoField <> 0, 'Yes', 'No') AS YesOrNo
> | from table
> |
> |
> | --
> |
> | ~ Kathleen Anderson
> | Microsoft MVP - FrontPage
> | Spider Web Woman Designs
> | Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> | FrontPage Resources: http://www.spiderwebwoman.com/resources/
> | Please reply to the newsgroup for the benefit of others
> |
> |
> |
> | "LauraK" <(E-Mail Removed)> wrote in message
> | news:CC2637D2-1BEC-4359-8ADB-(E-Mail Removed)...
> | >I have a FrontPage 2003 application form that feeds into a SQL table.
> | > Everything works great except on my custom confirmation page where Yes/No
> | > questions appear as True/False. Is there a way to change the confirmation
> | > page to display Yes if the answer is True and No if it is false?
> | >
> | > I've tried changing the code in the form using a dim statement but it
> | > isn't
> | > working. I thought it might be easier to just change the way the field
> | > displays on the confirmation page. Thanks!
> |
> |
>
>
>

 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      2nd Jul 2008
FP Confirmation pages do not support ASP
- the must be .htm pages

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


"LauraK" <(E-Mail Removed)> wrote in message news:97979A47-F147-40BE-A1EA-(E-Mail Removed)...
| Thanks Stefan, I'm not sure where to put it on the confirmation page.
| FrontPage inserts <!--webbot bot="ConfirmationField" s-field="Topic1" --> for
| the field. Would I include your code along with the webbot bot= or in place
| of?
|
| "Stefan B Rusynko" wrote:
|
| > Of for the field display itself
| > <% IF fieldname=TRUE THEN%>YES<%Else%>NO<%END IF%>
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > "Kathleen Anderson" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| > | I'm not sure what a Select statement looks like when using SQL, but could
| > | you try something like this?
| > |
| > | select iif(YesNoField <> 0, 'Yes', 'No') AS YesOrNo
| > | from table
| > |
| > |
| > | --
| > |
| > | ~ Kathleen Anderson
| > | Microsoft MVP - FrontPage
| > | Spider Web Woman Designs
| > | Expression Web Resources: http://www.spiderwebwoman.com/xweb/
| > | FrontPage Resources: http://www.spiderwebwoman.com/resources/
| > | Please reply to the newsgroup for the benefit of others
| > |
| > |
| > |
| > | "LauraK" <(E-Mail Removed)> wrote in message
| > | news:CC2637D2-1BEC-4359-8ADB-(E-Mail Removed)...
| > | >I have a FrontPage 2003 application form that feeds into a SQL table.
| > | > Everything works great except on my custom confirmation page where Yes/No
| > | > questions appear as True/False. Is there a way to change the confirmation
| > | > page to display Yes if the answer is True and No if it is false?
| > | >
| > | > I've tried changing the code in the form using a dim statement but it
| > | > isn't
| > | > working. I thought it might be easier to just change the way the field
| > | > displays on the confirmation page. Thanks!
| > |
| > |
| >
| >
| >


 
Reply With Quote
 
LauraK
Guest
Posts: n/a
 
      2nd Jul 2008
Thanks Stefan. I find your response interesting as I have an .asp
confirmation page that works just fine. But back to my original question,
you suggested I use
<% IF fieldname=TRUE THEN%>YES<%Else%>NO<%END IF%>. Is this statement going
on the confirmation page to change the way it is displayed or is it part of
the form field? If it goes on the confirmation page, where does it go?

"Stefan B Rusynko" wrote:

> FP Confirmation pages do not support ASP
> - the must be .htm pages
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "LauraK" <(E-Mail Removed)> wrote in message news:97979A47-F147-40BE-A1EA-(E-Mail Removed)...
> | Thanks Stefan, I'm not sure where to put it on the confirmation page.
> | FrontPage inserts <!--webbot bot="ConfirmationField" s-field="Topic1" --> for
> | the field. Would I include your code along with the webbot bot= or in place
> | of?
> |
> | "Stefan B Rusynko" wrote:
> |
> | > Of for the field display itself
> | > <% IF fieldname=TRUE THEN%>YES<%Else%>NO<%END IF%>
> | >
> | > --
> | >
> | > _____________________________________________
> | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> | > "Warning - Using the F1 Key will not break anything!" (-;
> | > _____________________________________________
> | >
> | >
> | > "Kathleen Anderson" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> | > | I'm not sure what a Select statement looks like when using SQL, but could
> | > | you try something like this?
> | > |
> | > | select iif(YesNoField <> 0, 'Yes', 'No') AS YesOrNo
> | > | from table
> | > |
> | > |
> | > | --
> | > |
> | > | ~ Kathleen Anderson
> | > | Microsoft MVP - FrontPage
> | > | Spider Web Woman Designs
> | > | Expression Web Resources: http://www.spiderwebwoman.com/xweb/
> | > | FrontPage Resources: http://www.spiderwebwoman.com/resources/
> | > | Please reply to the newsgroup for the benefit of others
> | > |
> | > |
> | > |
> | > | "LauraK" <(E-Mail Removed)> wrote in message
> | > | news:CC2637D2-1BEC-4359-8ADB-(E-Mail Removed)...
> | > | >I have a FrontPage 2003 application form that feeds into a SQL table.
> | > | > Everything works great except on my custom confirmation page where Yes/No
> | > | > questions appear as True/False. Is there a way to change the confirmation
> | > | > page to display Yes if the answer is True and No if it is false?
> | > | >
> | > | > I've tried changing the code in the form using a dim statement but it
> | > | > isn't
> | > | > working. I thought it might be easier to just change the way the field
> | > | > displays on the confirmation page. Thanks!
> | > |
> | > |
> | >
> | >
> | >
>
>
>

 
Reply With Quote
 
Stefan B Rusynko
Guest
Posts: n/a
 
      3rd Jul 2008
"fieldname" is the form field name/value used in your form

In ASP any form field name and it's value is obtained by using
<% formfield = Request.Form("yourfieldnamehere") %>
See http://www.w3schools.com/asp/asp_inputforms.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


"LauraK" <(E-Mail Removed)> wrote in message news:C8BF41AE-9477-49F5-8C5D-(E-Mail Removed)...
| Thanks Stefan. I find your response interesting as I have an .asp
| confirmation page that works just fine. But back to my original question,
| you suggested I use
| <% IF fieldname=TRUE THEN%>YES<%Else%>NO<%END IF%>. Is this statement going
| on the confirmation page to change the way it is displayed or is it part of
| the form field? If it goes on the confirmation page, where does it go?
|
| "Stefan B Rusynko" wrote:
|
| > FP Confirmation pages do not support ASP
| > - the must be .htm pages
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > "LauraK" <(E-Mail Removed)> wrote in message news:97979A47-F147-40BE-A1EA-(E-Mail Removed)...
| > | Thanks Stefan, I'm not sure where to put it on the confirmation page.
| > | FrontPage inserts <!--webbot bot="ConfirmationField" s-field="Topic1" --> for
| > | the field. Would I include your code along with the webbot bot= or in place
| > | of?
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Of for the field display itself
| > | > <% IF fieldname=TRUE THEN%>YES<%Else%>NO<%END IF%>
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > _____________________________________________
| > | >
| > | >
| > | > "Kathleen Anderson" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| > | > | I'm not sure what a Select statement looks like when using SQL, but could
| > | > | you try something like this?
| > | > |
| > | > | select iif(YesNoField <> 0, 'Yes', 'No') AS YesOrNo
| > | > | from table
| > | > |
| > | > |
| > | > | --
| > | > |
| > | > | ~ Kathleen Anderson
| > | > | Microsoft MVP - FrontPage
| > | > | Spider Web Woman Designs
| > | > | Expression Web Resources: http://www.spiderwebwoman.com/xweb/
| > | > | FrontPage Resources: http://www.spiderwebwoman.com/resources/
| > | > | Please reply to the newsgroup for the benefit of others
| > | > |
| > | > |
| > | > |
| > | > | "LauraK" <(E-Mail Removed)> wrote in message
| > | > | news:CC2637D2-1BEC-4359-8ADB-(E-Mail Removed)...
| > | > | >I have a FrontPage 2003 application form that feeds into a SQL table.
| > | > | > Everything works great except on my custom confirmation page where Yes/No
| > | > | > questions appear as True/False. Is there a way to change the confirmation
| > | > | > page to display Yes if the answer is True and No if it is false?
| > | > | >
| > | > | > I've tried changing the code in the form using a dim statement but it
| > | > | > isn't
| > | > | > working. I thought it might be easier to just change the way the field
| > | > | > displays on the confirmation page. Thanks!
| > | > |
| > | > |
| > | >
| > | >
| > | >
| >
| >
| >


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
boolean fields =?Utf-8?B?Q29ycmFkbyA5NQ==?= Microsoft Access Queries 1 8th Dec 2005 09:36 PM
how do I prevent shifting display in boolean fields?? =?Utf-8?B?TWljaGFlbCBHcmlmZml0aA==?= Microsoft Access 0 22nd Aug 2005 06:07 AM
Boolean fields in reports Andy Pryor Microsoft Access Reports 3 14th Sep 2004 01:26 PM
Re: Group By with Boolean fields Steve Schapel Microsoft Access Queries 0 10th Jul 2004 01:49 AM
Transferdatabase and Boolean fields Dorian Chalom Microsoft Access VBA Modules 2 1st Aug 2003 04:55 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:30 AM.