I have a couple pages that submits a form to an oracle database however and then I display a case number after the form is submitted. However, the records are not always being inserted at the end of the database. For example if I look at the case numbers in the database they are in this order: Code:
I'm creating a access database for 'events'. I have created a field for 'date of event', the asp then checks if this date has lapsed, if so it doen't show the event. All works fine.The only problem is how do I manage dates that re-occur ? i.e every tuesday or every 1st tuesay of the month.
The re-occuring event would have some general blurb that applies to all the dates, but on some occations I may need to add new unique info for forthcoming events. ie special guest. How would I design the dtatabase structure and asp code around this senario ?
is it possible to somehow "jump out of" an ASP page that is executed from another page via the Server.Execute method?
on the page being executed i have several instances where i need to stop the execution and immediately shoot back to the calling page without running through the rest of the code on the executed page. Code:
I have a middle-tier written using Foxpro. I'd like this tier to communicate (that is pass some variables to ASP). I defined a Session variable somewhere in my ASP file, e.g. Session("Usercode") = Somevalue. Now somewhere else, I want to change this value. I tried this: UserSession = CREATEOBJECT('ASPTypeLibrary.Session') UserSession.Contents("Usercode") = TheUsercode However, it gives the error: ASPTypeLibrary.Session is not found. However, VB's object browser lists this
i have an excel file from where i want to move every record into a database
the insert is working but..... after the insert the first record of the excel file is getting inserted at 168 th place in the table the first six rows in the table are have no entries after insert
the 18th row of excel file is the 7th record in the table after insert why is this happenin the insert statement is as below:
what Im trying to do is to insert into the database the values of the checked checkboxes of the recordset fields the appear in the table I've written the following code:
I AM NOT ABLE TO DISPLAY IMAGES FROM ACCESS DATABASE JUST 11 BLACK IMAGE BOXES OF SIZE 400 X 250 Code:
sql="SELECT [IMAGES] FROM ITEMS" rsAuthors.open sql, cnnNorthWind, 3, 3 %> <%Set rsAuthors = cnnNorthWind.Execute(sql) IF rsAuthors.EOF then 'No records found Response.End ELSE 'Display the contents DO WHILE NOT rsAuthors.EOF 'Response.BinaryWrite(rsAuthors("IMAGES")) %> <img src="image/<%=rsAuthors("IMAGES")%>" height="400" width="250"> <%rsAuthors.MOVENEXT LOOP END IF %>
I am workin on a project at home,asp vbscript website, n im having problems with inserting records into my database .. I am using a dsn-less ADODB connection, but it seems that some kind of security is preventing me from writing in the db.. i can access n retrieve, but NOT WRITE.. ive tried disabling every type of security, still doesnt work..
I use often a combo box on my ASP pages. each time a form is submitted, the value of the combo box returns to the first selection But is there a way to avoid this and show always your latest selection ?
i have learned database connectivity. I am facing some problems in inserting records to database using SQL. Please tell me the way to insert records using SQL. I received error about wrong arguments on following line.
where Rs is the RecordSet object, Query contains they SQL String, and DBConn is the Connection to my Microsoft Access database. I easily connected to the database and retrieved records using following command:
I am trying to create a multi upload image form and I am kinda confused in the database part of it. I have a form with 3 file browser as below (this is just an example):
how to insert multiple records in database?? i have this problem like i have this one form and there are three fields like the (quantity,unit,item name)..the item that will be inputted will vary, depending on the number of item to be inputted..
Ex. enter the number of item: 3 qty unit item_name 1. 2 pcs pencil 2. 2 pcs glue stick 3. 2 pcs clip (SUMBIT)
what should i do in order that these items will be inserted in just one insert statement?
I am having problems inserting checkbox data into my database. The string data from the text files in my form have no problems being inserted in the db. Code:
Is it possible to use CDONTS to send an email and INSERT a record to a database, once a form has been submitted. They work individually but I cant get the scripts to work together.
I'm having a trouble to insert data into the database. I can't understand what do I do wrong. I've got 2 pages , one is html with user registration form and another one is asp with the following code:
I have a project where i have to use an html asp application form to insert records into an sql database. My problem is finding resources online to practice with to learn, i have basic knowledge of ASP and have attended the microsoft 1 week course on Administering a 2000 SQL Database and i have designed a few small sites so i know html and javascript. I have the database side covered its just the VB code to take the form values and post them to the sql database.
I was wondering if anyone could point me in the right direction of sample codes to play around with as i cant seem to find any which relate to this project.
what I want to make actually is to take the results of a search engine that I use, which are in form of HTML or ASP and transport that results in a DataBase. For example, I wont to place as registrations in the DataBase the equivalents URLs and their descriptions from the results of search. I use MS Access, code asp, HTML , Javascript .
QUESTION! How can I insert the content from an HTML or ASP page into a dataBase? How can I determine from what point to what point a string it will be entered in the first cell of table and afterwards in the next and next ....
I am trying to create an application feature for an inventory database and I am wondering about the most efficient way to process the updates. Here's the background information: Code:
after a lot of searches to see if i can get such a code on the net, i've finally come to ask my questions here bcoz i can see bits of code here n there on net but not what i really want.
i have a form with a listbox(lstduty) on it. i have been able to populate it with data(dutyName)from table 'duty' from a sql server 2000 database.
now when a user makes multiple selection and click the 'add' button, i want to be able to add it to another table in the database as below: Code:
I want to insert the data into the MS Access Database using Visual Basic 6.0. Anybody please heplp me to tell the steps to insert the data into the database.
I'm trying to insert mutiple records into my database when the form is submitted.. My form has 4 textfields; serial1, price1, serial2 and price2.
I would like to insert serial1 and price1 as one record, then serial2 and price2 as the second record. I know some sort of loop has to be used to achieve this but i'm new to this and I don't know what to do...
I tried to do it with dreamweaver but it does not seem possible and the dreamweaver code seems really complicated I've only been able to insert only the first row(serial1,price1).. since I only have 2 fixed rows I guess what I need to do is to get dreamweaver to do it twice in a loop. Code:
vMessageText = "This is a test just to see if it will blow up on a large comment. Just testing again. Don't mind me."
Can I put this into my database field or is it too much and if not, how do I solve this issue. I need to be able to post messages and input for large fields.
I'm having a problem with passing variables inserting to my database. Here's what I'm doing. I have a page where the user selects a team member (this is fine) Once the team member is selected I have the variables on the form send and email to all supervisors and the member selected (this is fine also) BUT, I'm having problems inserting the emailed information to my access 2000 database after is email. Can someone guide me in the right direction.
I have a table that contains all of the function permissions within a given application. These functions are different sections of a site and each has its own permissions (READ, WRITE, UPDATE, DELETE) which are controlled by a web frontend and the table records are manipulated to control the permissions. Code:
my form contains two text fields(name, address) and two file field control where user can insert image(photo1 and photo2), i want to insert this data in to ms access when the user submits the form?
this is my code for insert text fields to access data base.but i have no idea about the code for image fields. In my access data base i set photo1 and photo2 as herf (binary data). Code: