I'm creating a record display page but one of the fields I need to display is stored as a number. Each number designates a different name (i.e. text). I know this is totally easy, but I can't figure out how to make the text displayed match the number its associated with.
I can do this easily with a drop-down menu, but I need normal text that can't be edited or anything. In other words, the field is 1, 2, 3, or 4. But it's entered by a drop-down where 1=name1, 2=name2, etc. Now I need to display those numbers in the database as the text they are supposed to be.
I'm using the follwoing code to retrieve some values from an Access database:
<% Dim PageStr PageStr=Request.Querystring("PageStr") SQL="SELECT * FROM images WHERE page = '" & Replace(PageStr, "'", "''") & "'" set conn = server.createobject("ADODB.Connection") conn.open "ContentDBase" set img=conn.execute(SQL) %>
This works fine. However, I want to change the 'page' field from a string to a number (i want to filter by the primary key rather than the description), but using the existing code I'm told I have a 'type mismatch' or something. I'm guessing I need to modify the code slightly to deal witha number field as opposed to a text field?
I have a form where you input year (number) and a Ref (number) and a section (char) and then submit to output a record, i added an if with a messageto prevent the eof and bof , and it is working if i inputed wrong numbers, but if i input text in the year or the ref, he will give the following message, how to prevent users from entering text into numbers fields, because in the database they are numbers, or what else could i do.
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. /iri_site/Importer/auth.asp, line 27
I am redeveloping a web site and changing the way it is setup, I have a lot of DB content, which is displaying text, as information. I have a number of words which I want to replace with links, and would prefer to do this dynamically as, going through all the text would ot only take ages but if it where updated remembering the links would be a pain.
Like they do on here, when your not logged in! and on loads of other sites. Is it feasible to do a replace statement for 50+ items, or is there a better way?
I have an invisible page counter. I have been successful in getting it to work. However, I'd like to build an administrative password protected web page that shows the count. I'm not sure how to do it. Here's my code for the file and path:
sPath = "D:inetpubwwwrootmywebsite.comdatabasecounter. txt" Set filesys = CreateObject("Scripting.FileSystemObject")
I have some values I'm passing from one form to another. When I press the submit button, I want the quantity I have in the text box on form a to pass to and display in the text box on form b.
form b is on an asp page, and I'm trying to display the values in this fashion:
myquantity=request.form("quantity")
response.write "<input type =text name=mybox value=" & myquantity & ">"
However, this is not working, and I can't figure out why.
I've created a db field with Memo type, and I have stored some text with carriage returns (no html) So the 3 words start on a differnt line. In access this displays correctly ( each word starts on a new line). However when I display these on a web page all the words appear on the same line.
I need the words to be displayed on a seperate line.
I'm trying to write a web form that will allow users update info from a database table. Everything is working fine, except the display of the one text field from the database (nothing displays. Here's what I'm trying:Code:
I'm working on asp project, access 2000 at backend.I can write arabic text and arabic numbers in textbox and save them in database.but if i see these records, arabic text and arabic numbers,it is ok,if my computer is arabicenable.
If my computer is not arabic enable then it show arabic number into english numbers. how can i show arabic numbers instead of english numbers if my computer is not arabic enable.i'm working on a project i have to complete it.How can i convert english numbers that are coming from database and convert that numbers in arabic for show.
I have use
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256"> I shall be very thankful to you for this purpose.
I have this problem in controlling a the text in a Text Area. How can I do that for example the field size is 200, when it reaches 50 it automatically goes to the next line. Bcoz im having problem when viewing it in my report, it continuesly views in a strieght line and im having problem in printing.
Now what I want is to add the checked values in page2.
For example :
if checkbox1 and checkbox3 gets checked I want to add the values in the checkboxes which in this case is 10 + 30 and get the total sum (40). Hope this makes sense?
So how do I retrive the checked values and then add the checked values with eachother to get the total?
i need to oredr a set of numbers. the numbers are "06/9","95/1","95/6","06/3" and so on. the thing is that these need to be ordered form the second number, so it shoudl be ordered thus: "95/1","06/3","95/6","06/9". how can i do this? at the moment just as an attempt im splitting the number either side of the "/" like this:
var regNo = "12/09" var yearStart = 0 var yearEnd = regNo.indexOf("/") var year = regNo.substring(yearStart, yearEnd) var itemStart = regNo.indexOf("/") + 1 var itemEnd = regNo.length var itemNo = regNo.substring(itemStart, itemEnd)
i know how to code it in javascript but failed to do it in asp. there are 12 digits of number. exmple like this 871205106599. i want to check every single digit when user clicks Submit button.
I believe this is possible using Regular Expressions (which I have never used), but I am unsure of any other way to do it. Either method would be acceptable for me - I need to learn how to use Regular Expressions some day How do you ensure that only numbers are entered into an input field. I need to know this for things like postcodes, phone numbers etc. and a few other things and I've never come across an easy way to do it
Can RSA encrypt a sequence of numbers and letters intermingled together. I was told that RSA can only encrypt letters,i'm not so sure. So can it bge done
Assume I enter number 1 in "from" and 10 in "to" - I want the ASP to return: 1,2,3,4,5,6,7,8,9,10 and insert this into an Access database over 10 rows into the 'number' field.
regarding adding or getting sum all of the numbers in the database fields example of the Fields:
Totay_Payment 10.00 20.00 30.00 40.00
My problem is i cant display the exact SUM of all numbers and it goes like this 10.0020.0030.0040.00 and i want the exact sum like this 100.00
heres the example of my script :
inTotalPayment = rsSumNumber("Total_Payment") Do While Not rsSumNumber.EOF intSum = intSum + intTotalPayment rsSumNumber.MoveNext Loop Response.Write(intsum)
I have a problem creating random numbers. I basically have this
Randomize() iRandom = Int(10 * Rnd + 1)
If I do not wait a few sec before hitting the page again it will create the same random number as generated a few seconds before.Any idea why it is like that? Another way to reprocess the "bug" is to just fit F5 few times in a row and you end up with the same number being generated. Its annoying and I need some help to "fix" it!
In our database I have various phone numbers, and they could start with 082 / 083 / 084 / 072 / 073 / 074. How do I check any of these and change them to 2782 / 2783 / 2784 / etc etc?
I've got an ASP app. This app is deployed to two seperate Windows NT machines which I believed were the same. Unfortunately, the app works on one PC, but on the other I get some EOleExceptions from the COM object I use with the page.
Does anyone know how I can check versions numbers of things like what ASP engine I am running (if there is such thing), version numbers etc. etc.
I'm just looking for anyway of telling what the difference is between the two PC's. P.s. I know this isn't really a 100% ASP based question, but I thought I would get a fast answer on the ASP board.
The number '60' can be written as (50+10) or (25+35) or (15+45) or (7+53) etc... but I want the output as (50+10) only when 60 is typed in a textbox & the Form is submitted. How do I do this?
