Add New Values To Access Double Fields - X100
I've got a really strange problem I can't explain - when I add new values into my database (Access) ir multiplies them by 100 - for example id I enter the values:
10.50
7.50
5.50
They go into the database as:
1050
750
550
The field in Access is a Double type, nullable, and set to default to 0.
My code to add it is: (the response.writes are what product the numbered output above - so I know what the form is posting, and subsequently what the database has in
its fields) Code:
View Replies
ADVERTISEMENT
I have an INSERT statement with information being pulled(upload.form) from the form. Example, text field named SubmitIssue1 will populate field SubmitIssue field in the database. SubmitDate1 will populate field SubmitDate1, and so on. However, what I am trying to accomplish is to expand the form to allow the user the ability to add another instance of an issue where they will use the SubmitIssue2 text area.
I want to pull their name and email address from the top of the form and use it as well as this new information in the SubmitIssue2 textbox to create a new record. The information from SubmitIssue2 will populate the SubmitIssue field. HOW CAN THIS BE DONE? Please help with some examples of how this would look. Code:
View Replies
View Related
I'm trying to retrieve 2 values from a table (product stocknumber & description) that match a form result (product ID number) to send with the "form results email". Not quite sure how to do this. Code:
View Replies
View Related
[Number of query values and destination fields are not the same.]
This file has worked with another project of mine but can't understand why it doesn't work with my current project.
I've look at the fields being queried and the fields being inserted and they are exactly the same. I basically made a copy of the main table and called it an archive table. So this is just taking out of the main table and inserting into an archive table. Code:
View Replies
View Related
I need to display multi-paragraph articles from a field in my database, but every time they display, they come up as one long paragraph with no line breaks, even though there are breaks within the database field.
I am using MS Access 2000 with field "data type" set to Memo and MM Dreamweaver UltraDev. What do I have to do to get the line breaks in the appropriate spots?
View Replies
View Related
I need to be able to retieve variable length (>255 characters) messages which have been saved in a memo field in an access data base on the server. I am using the following code to test this : -
<%
set objconn = server.createobject ("ADODB.connection")
set objrec = server.createobject ("ADODB.recordset")
objconn.open "DSN=daters"
strsql = "SELECT DISTINCT messages.* FROM messages WHERE messid = 305 ;"
objrec.open strsql, objconn, adopenforwardonly, adlockoptimistic,adcmdtext
%>
<%=objrec("text")%>
The message is found and retrieved but truncated to 255 characters as if it were an ACCESS text field not a memo field.
The message which is originally user created on another page, writes in full to the ACCESS memo field. Also, if I download the data, and retrieve the message offline via an ACCESS form, it displays fully. Seems then like an ADO issue in retrieving memo fields Probably my syntax?
View Replies
View Related
I have admins who create reports with titles that my code then creates a field with that title in another databse. The admins also apply permissions to staff whether they can see that report or not.
My problem is my code doesn't know the name of these new fields, is there any way in ASP to interegate the access field names in a record set?
View Replies
View Related
I have an ASP that displays two MS Access memo fields in separate table cells just fine. However when I concatenate them with SQL as in "select fld1 & fld2 as temp...." to display them in one cell only part of the first field is displayed in the table. What is causing this?
View Replies
View Related
what is the easiest way to display Yes/No, True/Falst, On/Off MS Access fields as check marks on an ASP page? it would be either checked or unchecked.
View Replies
View Related
I want to access the list of name from database with the combo box.
View Replies
View Related
im trying to connect to access and display some infor. from table. but it cant work, many errors occur, saying dat the<%language="VB" runat="server"ris not found in server. what i need to add in so that i can take infor. from acess? some codes.?
Example:
SELECT* FROM Detail... bla... bla... bla...
View Replies
View Related
This is my error in ASP. In my database i am having one field called title which contains some string including spaces . when i get this value into textbox in my web page
value is displaying but after space is not displaying .
View Replies
View Related
I have a request form that is used for requesting copies og an edition of a magazine. What I need to do is get back the information, from a MS Access table, for the issuedate and deadline.
Because the deadline is not always the same number of days (ie dependant on issue it could be 14 days before, or 21 days before etc), so as well as picking the issue date from the table, I need to be able to get the deadline date back, and write to a seperate Request "field" on the Form. Code:
View Replies
View Related
I'm using DWMX and Access DB.
i have setup a form on a normal http page which collects name address etc and is then passed to a https page to collect credit card details, on clicking submit on the https page the credit card details are inserted in db on secure server along with one field that was passed from the http page (the user id).
this all works ok, however i then need to pass the remaining orignal form values back to another http page that then inserts these values to another DB. ok you may be asking why.... the first forms allows the user to correct information already held on file before upgrading their listing, i then need them to pay for the upgrade before inserting the amended data in the orignal database... How..
View Replies
View Related
I have a search option on my website, which should perform a search on 4 fields, as follows:
tblNews
headline
content
tblDatabank
filename
description
It only needs to return matches which are an exact match of their search criteria. For instance, searching for "I am here" would return a record which contained "I am here", but not just "I" or "I am" etc.
I need to return all these records as part of one recordset preferably, as I want to be able to order them etc., though I imagine you may suggest I use an array somehow to merge two recordets etc., then reorder them?
View Replies
View Related
I have a form on an ASP page that has 5 text boxes, for data entry. I am trying to get data from the text box, and pass it to a hidden text box on the form.
The hidden text box is called "MyDateTime" (a SQL date and time value). I am attempting to concatenate data from two other textboxes (one for date and one for time) to give a string like : "8/8/2004 8:00 AM" I am trying to use the following: Code:
View Replies
View Related
I am pulling data from a table to create a <select> list. I need to wrap the value= in double quotes. Code:
View Replies
View Related
I have a form online, and I don't know if people are double clicking the submit button or what is happening really, but sometimes I will have two or more matching entries in a row. Is there any code I can use to filter out double clicks or tripple clicks even? These forms are done in asp and sent to sendcontactform.asp to process.
View Replies
View Related
how can I double split this string and pu the values into an array?
string = 2_3, 4_5, 6_8;6_9, 4_6; 3_1
I need the split after "," and ";"
View Replies
View Related
I have an asp page.I have all the form tags, javascripts etc in that. For e.g In my asp page I have mentioned my form tag as
<form name=frmupdateskill method=post>
and javascript as
<script language=javascript>
some code...
</script>
I send this asp page to my onsite person. When he replaces the old asp page with the one I sent the following are the things I come across. Code:
View Replies
View Related
I am using an HTML form to post data to my database, but when a users enter contact info into my database I am getting the same info twice, although the user only submits once. Here is my code:
sSQL = "INSERT INTO Lead_Data (username)" & _
"VALUES ('" & User_Name & "')"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "DSN=", "", ""
objConn.Execute(sSql)
objConn.Close
Set objConn = Nothing
Response.Redirect("addpass.htm")
View Replies
View Related
I'm trying to pass data from a <textarea> box to a confirmation page and then pass the same information from the confirmation page to a final page.
When the information gets passed to the final page it is truncating it where there are double quotes. I've tried to do a replace() function to try and escape the quotes out but it's not working.
confirmation page
Code:
<input type="hidden" name="results" value="<%=results%>" />
final page
Code:
results = request.form("results")
results = replace(results,""","""")
results = replace(results,vbcrlf,"<br />")
View Replies
View Related
What I would like to do is the following: Menu box 1 populates all 50 states from an SQL table. Use selects State. Menu box 2 gets populated from SQL table with Al counties in that State. User selects prefered county then hits submit The part I am having trouble with is populating the county menu box.
View Replies
View Related
I have a active server page where records are displayed from a query. The
display right now is read only. However, with text box this display can also
be edited. The first column shows category while the second category shows
category total sales.
I would like to double click on category field to get
to another asp page that would show the details of sales for that category
value double clicked.
My question is: If there is any double click event that would allow me to
pass values to open another asp page.
View Replies
View Related
I have an order form that dynamically populates item names and item ids from my MS SQL database. These values get put into three arrays that are looped based on the qty selected for insert into a cart table. Everything works except that the values are inserted into the database twice. Here's the insert code:
View Replies
View Related
Got a stubborn problem with double quotes
i can replace two single quotes but how do i replace a quotation mark e.g. (") and not ('')
Replace(rstSimple3.Fields("Description"), "''", " ") works
Replace(rstSimple3.Fields("Description"), """, " ") cuases error!
View Replies
View Related
i want to know how to include double quotes in " "
such as
somevariable=" "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("kb.mdb")" "
note this is example given by me.
i only want to know that
how to include double quotes within double quotes.
View Replies
View Related
I got to place a loop to create a call to javascript with different ID' s generated by asp like in the following code ...
View Replies
View Related
I need to output a string with double qoute ex. "$5.24" using asp and vb script. Greatly appreciate for any assistant.
View Replies
View Related
I am going to use the date as my filename. How can I convert date() ["5/18/04"] to "20040518"? Thanks a thousand.
View Replies
View Related
converting a single
digit (ie: 1, 2, 3, etc) to double digits (ie: 01, 02, 03, etc).
I am trying to convert the date in DD/MM/YYYY format so it is always displayed as 01/01/2004 instead of 1/1/2004.The script I am trying to embed this into has similar attributes to the Calendar on this site located at http://www.asp101.com/samples/calendar.asp.and the objects that require to be double digits are iCurrent and Month(dDate).
View Replies
View Related
I have some data string like ~!@#$%'^&(*("}[;asd"> which contains double quote and greater then sign, first I need to insert this value into database, second this inserted value I have display in a textbox by retriving from database, as it has "> at end of the string values are getting discarded.
View Replies
View Related
If rs("MyString") is Hello "Jim" Lad
<input type=text value="<%=rs("MyString")%>">
prints as <input type=text value=" Hello "Jim" Lad">
How can I get double quotes to display in a text box or textarea? Using a backslash or &Quot; (with Replace() e.g.) just prints out the backslash or &Quot;
View Replies
View Related