Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Frontpage
addins
client
extensions.unix
extensions.windowsnt
programming
programming.com_addins
programming.vba
  
 
date: Tue, 12 Aug 2008 01:04:01 -0700,    group: microsoft.public.frontpage.client        back       


Query and textbox   
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
date: Tue, 12 Aug 2008 01:04:01 -0700   author:   David8

Re: Query and textbox   
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"  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
date: Tue, 12 Aug 2008 04:33:25 -0400   author:   Stefan B Rusynko

Re: Query and textbox   
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"  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 
> 
> 
>
date: Tue, 12 Aug 2008 03:10:10 -0700   author:   David8

Re: Query and textbox   
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"  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"  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
| >
| >
| >
date: Wed, 13 Aug 2008 05:03:05 -0400   author:   Stefan B Rusynko

Re: Query and textbox   
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"  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"  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
> | >
> | >
> | > 
> 
> 
>
date: Wed, 13 Aug 2008 02:26:24 -0700   author:   David8

Re: Query and textbox   
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"  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"  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"  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
| > | >
| > | >
| > | >
| >
| >
| >
date: Thu, 14 Aug 2008 04:18:49 -0400   author:   Stefan B Rusynko

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us