Writing Values To Database.

I'm a newb - so if this is a stupid question, my apologies.

I have a simple form that users fill out and then that info is written to a database. What I'd like to do is perform a calcution on a number and then write those numbers to other records in the database.

So for instance, if someone enters 12 in one field1, it would multiply that by 3 and that would be saved as field2, then mulitply it by 45 and that would be field3, then add field2 and field3 and save that as field4.

I was thiking of passing the form variables to a second page instead of writing them to the database, then using variables in the second page to perform the calculations and then have the second page write all the info to the database, but I thought there had to be a better solution.

View Replies


ADVERTISEMENT

Writing Out Array Values

I have an array which has days of the month stored in it. For example at one
time it might have the values

1,2,3,6,7,8,9

at another time it might have the value

4,5,12,14,19,25

These are days of the month that have been selected and read into an array.
What i would like to do is to write them out and put a "X" where the days
were selected Code:

View Replies View Related

Writing To A Database

i am having problems figuring out the syntax used when writing information to a database thru a dropdown.
i have a dropdown w/ all the months listed and i need this recorded into a database where i have already set up a column named "month".
right now all i have is html that says:

Code:

<select name="month">
<option value="January">January</option>
<option value="March">March</option>
<option value="April">April</option>
....... and so on.......
</select>

View Replies View Related

Writing To ASP Database

I cant seem to right to my asp database... This is my code. Code:

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open Server.MapPath("/db") & "/db.mdb"
ors = Server.CreateObject("ADODB.recordset")
sql = "SLECT * FROM members"
ors.open sql,conn,adOpenDynamic,adLockOptimistic,adCmdText
This is the error message I get...

Object doesn't support this property or method: 'ors.Open'

P.S - I have adovbs.inc included.

View Replies View Related

Problem Writing To SQL Database

I have an asp form that sends data to a redirect page with SQL using JScript. There is a function that I'm using called replace(). The form submits without errors and goes to the redirect page but the data doesn't populate the SQL database. Instead, referrs to the last key ID. Code:

View Replies View Related

Writing Files To A Database

Does anyone know the ASP code for taking a PDF file and a Microsoft Excel spreadsheet and inserting them into an Oracle database?

View Replies View Related

Writing Records From A Database

After this statement, I want to be able to then show the data in the database in a recordor table view for the user. Any ideas?

'Check if username doesn't already exist
do while not rs.EOF
if rs("username")=Request("Username") then
set rs=nothing
set conn=nothing
Response.Redirect("login.asp?login=createnamefailed")
end if
rs.MoveNext
loop

View Replies View Related

Writing To An Access Database

i would like to write information to an access database. I have tried websites that have scripts but the ones i have saw are fairly complicated. All i have is a form for the user to input information and then i want it to write to a pasific table in microsoft access. how to do this.

View Replies View Related

Writing Multiple Lines Into A Database

When inserting multiple lines into a database asp removes the whitespace so:

hello
all

becomes

hello all

is there any way to detect the return and inset it as intended ie:

hello
all

View Replies View Related

Problems Writing Files To Database

I'm having some problems writing files to my Access database using ASP. I have a table with a couple of fields, one being of OLE datatype, that holds the file. I'm able to write and read small images, but I'm getting corrupted files when I try Word files, and my code is erroring out when I try to writing pdf files.

I think I've found the problem with the uploading of the pdf file (I think I need to adjust some IIS setting to allow larger file uploads), but I don't know what's going on with the word documents. They are small, so upload fine. Does anyone have any experience writing files to Access?

View Replies View Related

Checkboxes In Asp Writing To Access Database?

I am tring to create a front end for this Access Database someone has given me and i have trawled through these and other forums for the answer to my question but have not found anything!!

I have used 4 checkboxes in a form with 4 different names, when i try and create a record in the access database which uses the Yes/No Field Type it displays the error, " Provider error '80020005'

type mismatch" when trying to right the value into the field!

View Replies View Related

Writing Array Of Random Numbers To A Database

I am trying to write an array of random numbers to a database. The array part is working fine, but when I go to update the dataabse, it inserts the last value of the array into all the fields in the database .....

Dim MyValue,sqlRandom
Dim arrayRandom(8)
for i = 1 to 8
Randomize
MyValue = Int((100 * Rnd) + 1)
arrayRandom(i) = MyValue
response.write "<p> Array Value:" & arrayRandom(i)

sqlRandom = "UPDATE CarParkDetails SET FreeSpaces = '" & arrayRandom(i) & "'"
Conn.execute(sqlRandom)

next

I can't see whats wrong!

View Replies View Related

Update Values In Database

We have a fairly large datbase containing thousands of part numbers, product names and pricing. We used to update new pricing changes individually by hand. However, now that our database has grown substantially, I'm wondering what the best method would be to keep the pricing current on our database?

We can obtain new price lists in excel format, however, the part numbers the mfgs use may not necessarily coincide with the part numbers we have. Should I just write some SQL script? Look into using XML? What would be the most efficient way to tackle this problem?

View Replies View Related

Grabbing Values From Database

I was playing around in FrontPage and I noticed that you could insert an ActiveX control for a calendar. I would like to be able to use this to integrate with a database - for example, I would like to be able to click on a day of the month and have the page display all data associated with that date (sort of a select * from database where date = "date_clicked_on")

View Replies View Related

Random Values From Database

Suppose I have a table named as tblfriends and there are 3 columns with several row. Column names are: name, email, phone

I want to pick 5 names randomly from the table each time my asp page refreshes. How can this be coded in classic asp?

View Replies View Related

Adding Up Values From A Database

I am trying to add entries in a database together and place the summed value into a text box. Like a total ordered type function for an ecommerce site. I have a field called ArmChairs in my database and based on how many people buy them, I want to know how many I need to have shipped.

I am really struggling with this last bit and would be really appreciative if someone has some code examples.

View Replies View Related

Getting Values From Access Database

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

ListBox Values From Database

I want to populate a listbox from a database. This listBox will contain the value of the Table PK. Whenever i chose an ID the input fields in the form below will change corresponding to the PK.

View Replies View Related

Show All Values From My Database

I have a problem with show all values from my database into my html page! Code:

View Replies View Related

Get Database Values And Change Them To A Letter

I have a dynamic table asp/vb that is returning records as expected. There are 7 fields that are returning boolean values based on whether there is or is not a meeting on those given days.

My table is returning TRUE and FALSE and all I want to do is create an if or select statement that will detect the values in these fields and change them as follows:

If true, then field = "R" (Wingdings2 R is a checked box)
If false, then field = "T"(Wingdings2 returns a x'd out box)

View Replies View Related

How To Retreive Nonrepeatable Values From Database

I have a problem with retreiving non repeatable values from database.(this is a shopping cart application)I wrote the query as below,but it didn't work

sql="SET ROWCOUNT 10 select distinct(product_name),pdate from addcart order by pdate desc".

Actually iwant to see recently viewed produts name (max 10)
for this iam retrieving values from addcart table.
By executing above query iam getting 10 products name but they are repeatable.

View Replies View Related

Retreive Checkboxes Values From Database

I have a form that users use to register with the site. On this form there are checkboxes all with the same name but different values. I am creating another page that will allow users to login and edit their information.

Since all the data from the checkboxes are stored on the database under the same field name and separated by commas; how do I dynamically create a set of the checked checkboxes that the user originally entered along with the other checkboxes the user did not click?

View Replies View Related

Problems With Inserting Form Values In Database

I made a 2 web surveys with identical code. Although the code is similar in both, values on the last page of one of the survey do not go in the database.

I have tried playing around (coz I really dont understand what the problem is), but nothing works. The same code works on the other survey with absolutely no problems.All thats there in my survey to insert values is

.Fields ("fieldname") = Request.value ("name of text box")
.update

Any suggestions? If someones willing to help me out quick, I will post my code.

View Replies View Related

Getting The Count From Database Where All Initial Values Are Empty

I have a registration form that I'm making and I need to get the count of available spots for each class session. I can't get the array to return something like "0,0,0,0,0,0". Is there a way to do this? There are 6 total classes and they are named 1, 2, 3, 4, 5, and 6.

When you start out, each count will be 0 (meaning no one signed up yet) which makes the openSpots variable equal to 35 (maximum # allowed). Code:

View Replies View Related

Is It Possible To Insert All Checkbox Values Into 1 Field In The SQL Database?

Is it possible to insert more than 2 checkbox values into 1 field in the SQL database?

I have 5 checkboxes; I would like to insert them all into 1 column in the SQL DB.
If I insert more than 2, it gives an error.

View Replies View Related

Building Dynamic Strings From Database Values

We use an ASP application in which we send out emails using cdo for various
events.

At present the email text is hard coded into the code. for example

strMessage = "Dear " & rs("firstname")
strMessage = strMessage & "Your request has been approved with reference id
" & rs("id")

This causes an administration overhead as everytime the text of the message
needs to be changed we need to alter the code to incorporate text or
database values.

What we want is to store the message text into a table so it can be altered
by the application administrators through GUI by adding the text through
freetext entry and field names though a dropdown. Code:

View Replies View Related

Have To Create Hyperlinks Dynamically Based On The Values From Database.

I have certain Keywords stored in a table of the Database.All i need is when ever i find the Keyword in the webpage i need to have a link which opens up as a seperate page and give me the detail information from the database for the seleted keyword.

View Replies View Related

Matching Array Index To Values Retrieved From Database

I have this dynamic array(shown below) that I need to match to values (1 - 10) that I am returning from the database via DSN connection object.

The values I need to match are on the same page (in their own table) but I am not sure how to match up the array indexes to these values. I want to be able to display the array result as part of or nested in another table. Code:

View Replies View Related

Form Values With A File - Passing Values

I want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:

To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:

View Replies View Related

How To Convert Escape Values In To Actual Values

i need to convert the escape values which are by mistake updated in DB.
example:

this is a sample text string
is updated in DB as
this%20is%20a%20sample%20text%20string

here %20 is the space.

like wise there are many entries for :,'

is there way that i can update all this in a update statement?
or use asp to to update the records?

View Replies View Related

How To Extract Indiviual Values From A Set Of Values

I have a variable SET which has the value Of 1, 2, 3, .., N.

SET=val1, val2, val3, val4, ..., valN

What is the commend or procedure to extract individual values, val1, val2, ...

View Replies View Related

Writing To DB

Ok, for my company, we have two current webpages, one for general company info and one specific to a product that we market. On the 2nd page, there is a form that allows users to request a consultation from the company. When it is sent, the information is stored in an Access DB for tracking purposes.

Now, I have been requested to put this same form on the general company website. All works fine, but I can't save to the db that is stroing the info once it is submitted. Boith sites are hosted by the smae company, but they do not have (as far as I know), a shared repository for files where I could put the db.

Does anyone have any suggestions as to how I can get around this issue? What I want to do is to have the form on both sites and have the submitted data saved into the one database.

View Replies View Related

Not Writing To My DB

I'm not getting error messages on this one so I don't know where to start looking. I type in my data in my form and this page should check it, add it then set a flag. Code:

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved