(Msg. 1) Posted: Tue Aug 12, 2008 1:04 am
Post subject: Query and textbox Archived from groups: microsoft>public>frontpage>client (more info?)
Hello from Barcelona,
I have a page that when it is loaded must add a field of text that contains
a fixed value and a field of text that is the result of a query. All good
except when the query, for the motive that is, does not return any value
because it is empty.
Since I can do in order that this box of text that must to contain a value
appears with value zero? I say it because when the query does not contain
records the box of text disappears and in his place there appears the text "
No returned record ".
Thank you in advance,
(Msg. 2) Posted: Tue Aug 12, 2008 4:33 am
Post subject: Re: Query and textbox [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
How are you generating the query results?
- using hand coded ASP, or using the Database Results Wizard?
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
"David8" <David8.RemoveThis@discussions.microsoft.com> wrote in message news:A5D4B4C6-F1AF-4CA0-BCE6-866523C4A8C4@microsoft.com...
| Hello from Barcelona,
|
| I have a page that when it is loaded must add a field of text that contains
| a fixed value and a field of text that is the result of a query. All good
| except when the query, for the motive that is, does not return any value
| because it is empty.
| Since I can do in order that this box of text that must to contain a value
| appears with value zero? I say it because when the query does not contain
| records the box of text disappears and in his place there appears the text "
| No returned record ".
| Thank you in advance,
|
| David8
(Msg. 3) Posted: Tue Aug 12, 2008 4:33 am
Post subject: Re: Query and textbox [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
With Database Results Wizard, and all is in a form.
Thanks,
David8
"Stefan B Rusynko" wrote:
> How are you generating the query results?
> - using hand coded ASP, or using the Database Results Wizard?
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "David8" <David8.RemoveThis@discussions.microsoft.com> wrote in message news:A5D4B4C6-F1AF-4CA0-BCE6-866523C4A8C4@microsoft.com...
> | Hello from Barcelona,
> |
> | I have a page that when it is loaded must add a field of text that contains
> | a fixed value and a field of text that is the result of a query. All good
> | except when the query, for the motive that is, does not return any value
> | because it is empty.
> | Since I can do in order that this box of text that must to contain a value
> | appears with value zero? I say it because when the query does not contain
> | records the box of text disappears and in his place there appears the text "
> | No returned record ".
> | Thank you in advance,
> |
> | David8
>
>
>
(Msg. 4) Posted: Wed Aug 13, 2008 5:03 am
Post subject: Re: Query and textbox [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You can edit the value shown when there are no DB Results
In Code view in the DBRW Grey Code look for the text in the variable:
s-norecordsfound=
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
"David8" <David8 RemoveThis @discussions.microsoft.com> wrote in message news:F89E04A2-A77E-450A-AD9C-0F0C71BB5FCD@microsoft.com...
| Hi,
| With Database Results Wizard, and all is in a form.
|
| Thanks,
| David8
|
| "Stefan B Rusynko" wrote:
|
| > How are you generating the query results?
| > - using hand coded ASP, or using the Database Results Wizard?
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > "David8" <David8 RemoveThis @discussions.microsoft.com> wrote in message news:A5D4B4C6-F1AF-4CA0-BCE6-866523C4A8C4@microsoft.com...
| > | Hello from Barcelona,
| > |
| > | I have a page that when it is loaded must add a field of text that contains
| > | a fixed value and a field of text that is the result of a query. All good
| > | except when the query, for the motive that is, does not return any value
| > | because it is empty.
| > | Since I can do in order that this box of text that must to contain a value
| > | appears with value zero? I say it because when the query does not contain
| > | records the box of text disappears and in his place there appears the text "
| > | No returned record ".
| > | Thank you in advance,
| > |
| > | David8
| >
| >
| >
(Msg. 5) Posted: Wed Aug 13, 2008 5:03 am
Post subject: Re: Query and textbox [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
I know i can change the text, but i need text in a textbox. If the query
returns no records found, the format of query is a plain text not a textbox.
Thanks,
David8
"Stefan B Rusynko" wrote:
> You can edit the value shown when there are no DB Results
> In Code view in the DBRW Grey Code look for the text in the variable:
> s-norecordsfound=
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "David8" <David8.TakeThisOut@discussions.microsoft.com> wrote in message news:F89E04A2-A77E-450A-AD9C-0F0C71BB5FCD@microsoft.com...
> | Hi,
> | With Database Results Wizard, and all is in a form.
> |
> | Thanks,
> | David8
> |
> | "Stefan B Rusynko" wrote:
> |
> | > How are you generating the query results?
> | > - using hand coded ASP, or using the Database Results Wizard?
> | >
> | > --
> | >
> | > _____________________________________________
> | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> | > "Warning - Using the F1 Key will not break anything!" (-;
> | > _____________________________________________
> | >
> | >
> | > "David8" <David8.TakeThisOut@discussions.microsoft.com> wrote in message news:A5D4B4C6-F1AF-4CA0-BCE6-866523C4A8C4@microsoft.com...
> | > | Hello from Barcelona,
> | > |
> | > | I have a page that when it is loaded must add a field of text that contains
> | > | a fixed value and a field of text that is the result of a query. All good
> | > | except when the query, for the motive that is, does not return any value
> | > | because it is empty.
> | > | Since I can do in order that this box of text that must to contain a value
> | > | appears with value zero? I say it because when the query does not contain
> | > | records the box of text disappears and in his place there appears the text "
> | > | No returned record ".
> | > | Thank you in advance,
> | > |
> | > | David8
> | >
> | >
> | >
>
>
>
(Msg. 6) Posted: Thu Aug 14, 2008 4:18 am
Post subject: Re: Query and textbox [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Not sure it will work,
- but try wrapping the text in a tag
s-norecordsfound="<input type='text' name='fieldname' size='20' value='No Record'>"
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________
"David8" <David8.DeleteThis@discussions.microsoft.com> wrote in message news:7557EB46-F666-4A70-8F60-2B81A122890C@microsoft.com...
|I know i can change the text, but i need text in a textbox. If the query
| returns no records found, the format of query is a plain text not a textbox.
|
| Thanks,
| David8
|
| "Stefan B Rusynko" wrote:
|
| > You can edit the value shown when there are no DB Results
| > In Code view in the DBRW Grey Code look for the text in the variable:
| > s-norecordsfound=
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > "David8" <David8.DeleteThis@discussions.microsoft.com> wrote in message news:F89E04A2-A77E-450A-AD9C-0F0C71BB5FCD@microsoft.com...
| > | Hi,
| > | With Database Results Wizard, and all is in a form.
| > |
| > | Thanks,
| > | David8
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > How are you generating the query results?
| > | > - using hand coded ASP, or using the Database Results Wizard?
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > _____________________________________________
| > | >
| > | >
| > | > "David8" <David8.DeleteThis@discussions.microsoft.com> wrote in message news:A5D4B4C6-F1AF-4CA0-BCE6-866523C4A8C4@microsoft.com...
| > | > | Hello from Barcelona,
| > | > |
| > | > | I have a page that when it is loaded must add a field of text that contains
| > | > | a fixed value and a field of text that is the result of a query. All good
| > | > | except when the query, for the motive that is, does not return any value
| > | > | because it is empty.
| > | > | Since I can do in order that this box of text that must to contain a value
| > | > | appears with value zero? I say it because when the query does not contain
| > | > | records the box of text disappears and in his place there appears the text "
| > | > | No returned record ".
| > | > | Thank you in advance,
| > | > |
| > | > | David8
| > | >
| > | >
| > | >
| >
| >
| >
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other