Query and textbox

  • Thread starter Thread starter David8
  • Start date Start date
D

David8

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
 
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!" (-;
_____________________________________________


| 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
 
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!" (-;
_____________________________________________


| 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!" (-;
| > _____________________________________________
| >
| >
| > | 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
| >
| >
| >
 
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
 
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!" (-;
_____________________________________________


|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!" (-;
| > _____________________________________________
| >
| >
| > | 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!" (-;
| > | > _____________________________________________
| > | >
| > | >
| > | > | 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
| > | >
| > | >
| > | >
| >
| >
| >
 
Back
Top