Displaying 2DP In Textboxes
When I retrieve this data into standard text boxes (using ASP/ADO) so that
the user can update/file the following problems occur on what I would call
price fields:
10 << I want 10.00
11.6 << I want 11.60
12.89 << this is fine
My MySQL DB holds prices as decimal(10,3) so I know the decimal data isn't
chopped at this point.
Before the data is displayed in these boxes I created the below function to
parse the data before it is written to the boxes: Code:
View Replies
ADVERTISEMENT
I have two textboxes, nett, vat and gross value.Nett and vat are entered manually, is there a way to say, when nett textbox lostfocus or vat lostfocus then add the two and show the value in the gross value textbox WITHOUT calling the page again as i would have to do in vbscript?
View Replies
View Related
I have 6 textboxes where if I fill them up I want the query to search if either one of them has results found. I have this but it's not working:
SQL = "SELECT * FROM bible WHERE "
SQL = SQL & "text_data LIKE '%" & Keyword & "%' OR "
SQL = SQL & "text_data LIKE '%" & Keywordb & "%' OR "
SQL = SQL & "text_data LIKE '%" & Keywordc & "%' OR "
SQL = SQL & "text_data LIKE '%" & Keywordd & "%' OR "
SQL = SQL & "text_data LIKE '%" & Keyworde & "%' OR "
SQL = SQL & "text_data LIKE '%" & Keywordf & "%' AND "
SQL = SQL & "book_spoke = '" & spoke_number & "'"
iCounter = iCounter + 1
(I would like to know the use of the iCounter since I use it from other examples but don't know why it's there.)
I've tried this too but this gives every record within
"book_spoke = '" & spoke_number & "'"
Code:
View Replies
View Related
All of a sudden about 50% of my textboxes are yellow (as opposed to theusual white color). It started when I started on an ASP project, but this could have been coincidental. I have noticed that it shows yellow textboxes on many other webpages.
View Replies
View Related
The input forms are created using FORMMANGER of MS Visual Interdev 6.0(ASP Code). The forms containing textboxes and bottons (with disable property) are shown correctly in IE5. But when same forms are viewed in IE6 the disabled textboxes and buttons are shown distorted.
View Replies
View Related
Ho can i loop through textboxes and then collect the data filled into them.I've done one for checkboxes but can't get my head around doing the one for textboxes.
View Replies
View Related
Someone have a script to insert dynamic items in the form?
For example...
In my default form have 5 textboxes... I need to put a button to users to "add new item"... and add textboxes to the form.
View Replies
View Related
i need to get the values from the stored procedure below, basically the Name, Description, and is Active values and display them in two textboxes and a checkbox. How can i do this? Or can it be done with this stored procedure? I havent been able to find any good examples on the web... Code:
View Replies
View Related
if i have an standard excel file and i have data in there in specific cells. Is it possible to have some upload facility that will be able to paste it to specific asp form textboxes?
e.g if the data in the excel file was in cell c4, i would want to paste it into textbox4. Is that possible.
OR
Is it possible to upload an excel file and to put specifc data from different cells directly into an access database.
e.g excel file -c4 i would want to paste it to rs("test4")
View Replies
View Related
I’ve a few radio buttons; few of them have input textboxes and dropdown list.
I use Select case to insert values (depend on which radio button that you've selected) into the sql db but it doesn’t work. Then I use if, elseif and else…the value of radio still doesn’t insert into the DB. In this case how can we insert the value(s) into the DB? Code:
View Replies
View Related
I have two URLs. Static.htm and dynamic.asp
Static.htm
Contains a form with two text boxes, called text_1 and text_2 and some other info that is irrelevant for my question.
Dynamic.asp
Need some code to check that the text boxes only contain values greater than 0 and only numbers. Thus if any of the textboxes for example contain -3 or the letter m I want to cancel the form submission and display some kind of error message.
How can I achieve that?
View Replies
View Related
I have XML and XSL documents stored in SQL Server 2000 field. On the asp page i will be getting these documents from the database and then displaying the content of the XML document according to the XSL on the asp page. How can i do this?
Also after getting the documents from the database do i need to store these on the server as .XML and .XSL and then read through these or i can directly read from these document without saving these physically.
Archived XML and XSL documents are attached.
View Replies
View Related
I'm pulling data into ASP from Sybase IQ. When the data is in the
database its displayed correctley: //C://.... When I pull it into an
asp page, the formating changes, and a few of my slashes disappear. Is
there a special method of pulling slahes into asp?
View Replies
View Related
I have this error: [object Error] WinHTTP returned error: 12006 The URL does not use a recognized protocol Code:
View Replies
View Related
Say i have the following names displayed on a page.
ABCD
CDFG
FGHI
Now if i click on ABCD,this name should get displayed in the text boc.I dont want to have a submit button.
I just want to basically select this name and the moment i select this name ,it gets displayed in the text box and thn i hit submit and the value in the text box hits the DB.
View Replies
View Related
I have an access database and users can search through it. Is it possible to display the first 20 results on one page and then display the next 20 on another page and so on and so on..
View Replies
View Related
I have a requirement to display a message and then redirect the controls to
some file, I tried with the below method but its not working, where as If I
use server.transfer or server.execute it works but I cant give relative Url
(it will dynamically genrate), If any one has an alternate way, pls respond.
ShowMessage("Hello World")
Sub ShowMessage(sMessage)
Response.Write "<script> alert("& Chr(34) & sMessage & Chr(34) &" );
</script>"
Response.redirect "xyz.asp"
End Sub
View Replies
View Related
I'm sure I'm missing something completely obvious, but I can't figure out what. I have a path to an image file stored in a database. I'm trying to align the image to the right, but nothing seems to be working:
Response.Write("<img src='" & rs("faculty_link_to_photo") &"'>")
dispays the photo without any wrapping, but when I try the following, the images go all over the page:
Response.Write("<img align=""right"" src='" & rs("faculty_link_to_photo") &"'>")
Can someone tell me what I'm doing wrong?
View Replies
View Related
I have ASP (classic) code that writes out a table and sets the <img....> tag
with a virtual directory source, e.g. src='/test/imghold/xyz.png', and the
images do not appear on the IE page. The code is from a production site
that works fine.
We just duplicated the web site to one named test and now
the images do not display. The IMG item is in a TD element of a table.
Also, I looked at the "view source" of the page and it shows the <IMG
src='/test/imghold/xyz.png'...> just fine. I even tried it with different
images and none of them show up.
View Replies
View Related
I have a web page that displays properties for sale. The web page links to a database.
The page shows information in the database and the path to the picture.
The code is:
<p><img border="0" src="file:///D:/HousePics/<%response.write
rsData("id")%>.jpg" width="350" height="262"></p>
the rsData("id")% gives the name of the picture file and appends .jpg to it.
When I browse the page on the local machine the page displays ok and the
graphics show up ok.
When I browse to the page at work the grpahics don't show.
Permissions on the folder 'everyone full control', web sharing is enable
for the site.
View Replies
View Related
Following is a function on button click event to display the details of an user.if i include this function page is not displaying.can u tell me where the mistake is? Code:
View Replies
View Related
I done Internet presentation for my client and presentation is placed on Brinkster...
Displaying movies is a part of presentation...
Those are .mov files...
As movie container I use Quicktime...
My problem is:
I have to wait to full movie loading...
Wait and wait...
When the movie is loaded then display starts...
Sometimes, it can take a long time...
I want to achieve effect with movie slider in my Quicktime container...
In other words, I want that movie begins to play before the end of full loading...
How can I achieve this?
My code is here:.....
View Replies
View Related
This code displays all the pictures in a defined folder as thumbnails. That works fine. But I would like to have it roll over onto a new page after a certain number of thumbs have been displayed and a back forward message. Code:
View Replies
View Related
I have a loads of records in an Access database relating to publications. The publications come in 3 forms, pdf, Word or .htm so I have fields for each called PDFurl, Wordurl and Publink. What I want to do is, if any of those fields contain a value then display an appropriate icon (which will link to the publication).
I'm ok with the latter part but how do I determine if any of the fields have a value and if so display the relevant icon? Rather than do a load of if then statements I was wondering is there a quicker way of doing this, perhaps using a Case?
View Replies
View Related
Firstly, I am not a programmer, so forgive my complete and utter ignorance of all things ASP related.I am trying to display an RSS feed on a website using some ASP which I found on this website - http://www.tele-pro.co.uk/scripts/rs...d_class_dl.htm
I have downloaded the script and running it locally it works (kind of):-
However, when I put this page on my web server I get an error message:-
http://www.ubsigroup.com/testing/
The ASP file is here:-
http://www.ubsigroup.com/testing/rss...ed_class.1.txt
View Replies
View Related
I have a fairly simple (at least in PHP) request but I can not find how do do it. I've seen things that are kindof what I want but not really. Here is what I want:
I have a ton of data in a DB. I want to pull some of that data and display it in a table. In PHP I would create a SQL query called $Result "(SELCT * FROM whatever)" and produce this code:
View Replies
View Related
I have an asp page in which I am performing the following:
1. Querying a database view
2. Returning rows in to a recordset.
3. Looping thru the recordset and printing the data
4. Before displaying the data I am assigning the values from the recordset
into variables
5. There are 2 entry points to this page both of which would run similar
queries and return similar results
My problem is that for a certain sequence of variable assignments, my data
is not displaying on the screen (even though when i do a response.write I
see that the variable actually has a value in it). In order to fix it I
rearranged the sequence of assignments but since I have two entry points to
the page, it didnot display the data for the other entry point.
View Replies
View Related
I have IIS 5.0 configured in win2k server. When I browse a html I have no problem. But when I browse an asp page, the browser is hanging around.
View Replies
View Related
I only just noticed this on a peice of work i completed. I used JavaScript and ASP to complete the project. A line of my code -
Response.Write("<td align='right' class='results'>" + MyQuery('Date') + "</td></tr>");
was used to show the date (readign from an access database) on the page but the output which was returend in the browser was -
Thu Jul 25 00:00:00 UTC+0100 2002
instead of the date the format - 25/07/2002
is there anyway i can change this so it displays ont he page exactly how it is shown in the access database
View Replies
View Related
After a user selects the 'answer' hyperlink, the answer will be pulled from the database and displayed.
Then i would like another link once selected to remove the displayed answer from the screen. It is important that the answer is not permanently deleted from the database.
I would like to do this for a series of questions.How can i do this?
View Replies
View Related
I am currently working on ASP. Users will input their contents into a textarea. The problem is that when they input and I retrieve them from the database, they will use the textarea space that was allocated to them and display exactly it is.
For example the text area given is 500px and i only give the display part of 250px. Despite that, it will fill up and scrollbars will appear on my bottom of the webpage and have to scroll to the right.
how i can display all text with the break lines in between yet still confined to the space of 250px.
View Replies
View Related
Is it possible to show different information on a page for different users?
For example a first year student that needs to select modules for this year compared to a second year student how would have to select different modules.
View Replies
View Related
I am trying to display data pulled from a sql db in a text area. The field in the db is of type ntext. I am printing the data using the following code.....
<TEXTAREA name="HTML" COLS=100 ROWS=21>
<%Response.Write(rsCreativeElement("ElementHTML"))%>
</TEXTAREA>
But this is printing as <Long Text>, how can I print the actual data from the db.
View Replies
View Related