I have a page where the user logins in and is taken to another page. On this page i want them to insert data into another table within my database.
At the moment however it just enters data into the database once. I'm assuming it�s because I don't have a recordset set up. How do get the ID of the user so that it will insert the new data into the relevant recordset.
I am having a problem with entering long ammounts of information (roughly 400 characters) into a database. The database field is set to memo.
Seems that whenever I want to enter strange characters it gives me an error. (I need to enter strange characters for an important reason).
Also I am having some problems with using ASP on Netscape (not testing...just clients are having problems). Does anybody have an idea of whats going on??
I would like to know if and how it would be possible to create an
entry-screen that allows the user to enter data in a database, using a
spreadsheet/table-like entry screen. The screen would start of having
headers for each column/field and an empty row underneath. When each column
in the row is filled in, the user must have an option to add another row.
I'm look for the code/explanation that helps me set up the entry screen, and
the ASP code to add the entered data in the database.
I can imagine that each entered row is added to the table when a new row is
added, or a button is pressed and then the screen refreshes with the newly
entered information and a new row...
i want to display data which is in access database and one date field, i want to show a data from date1 to from date 2.
View Replies View RelatedI am new user of ASP and as well as this forum, i want to make a web page, to enter data,in which , first user login page, then he enter data on his authorize database, database names are same as user login name.
e.g if someone login as user xyz he must open xyz.mdb, and if other login as abc he must open only abc.mdb to enter data, and data entry page must validate fields such that numeric fields, text fields, numeric lenght, etc
I'm trying to create an interface for manipulating historical stock prices obtained through finance.yahoo.com. I need to make a recordset contain the data of a CSV file that Yahoo returns, but the catch is that I want to pass the data along by pointing the recordset to the URL of the CSV files on the Yahoo server.
Yahoo creates its CSV files dynamically through the querystring of its URL (see below), and I would use inputs to my interface to manipulate the URL for specific ticker symbols, dates, etc.
I guess the simplest example is that a user could input a ticker to my interface, the recordset would somehow "call" the URL for the correct data, and then that data would be in the recordset, where I could manipulate it, before returning the information back to the user.
I'm just stumped on how to get the CSV data into the recordset on the fly, just by calling the URL.
The following link is an example of what Yahoo does. Manipulating the querystring changes the ticker, date range, and level of detail. You can also change the table.csv to table.txt and return the actual data in one big text file. Code:
I am using VBScript - (asp pages)
I want the person to enter a Part Number into a field
Example R3HAA0001-CP
But the person may not know the whole Part Number and enter
Example 3HAA
I want to use a wild card to make sure the person gets the correct Part Number.
I want to stay on the same screen, list the Part Number and Description - now if the person doesn't know the whole number and enters only a partial - I want all of the Part Numbers that match the criteria.
I'm having a bit of a problem and I was hoping someone could help me out. I'm trying to create an interface for manipulating historical stock prices obtained through finance.yahoo.com. I need to make a recordset contain the data of a CSV file that Yahoo returns, but the catch is that I want to pass the data along by pointing the recordset to the URL of the CSV files on the Yahoo server.
Yahoo creates its CSV files dynamically through the querystring of its URL (see below), and I would use inputs to my interface to manipulate the URL for specific ticker symbols, dates, etc. I guess the simplest example is that a user could input a ticker to my interface, the recordset would somehow "call" the URL for the correct data, and then that data would be in the recordset, where I could manipulate it, before returning the information back to the user.
I'm just stumped on how to get the CSV data into the recordset on the fly, just by calling the URL.
The following link is an example of what Yahoo does. Manipulating the querystring changes the ticker, date range, and level of detail. You can also change the table.csv to table.txt and return the actual data in one big text file. Code:
I’m in the middle of designing a simple website poll... nothing to fancy a simply question and results type thing... however I’ve hit a problem in that I cannot figure out how to add one to the running total when a vote is cast. For example:
Do you like this website:
A: Yes Lots – radio button if selected adds one to yeslots column
B: It’s ok - radio button if selected adds one to Itsok column
C: It could be improved - radio button if selected adds one to Itcouldbeimproved column
And of course we’re using an Access database for this one.
I have two tables, one called tblManufacturers and one called tblModels. tblManufacturers is already populated but now I have to enter the following models which correspond to the ID of the manufacturer into the tblModels table. Any ideas of how I can do this. Code:
View Replies View RelatedI need to create a text field so that users can enter in a specific date in uk format.
View Replies View Relatedi have my database in MS Access. a table name products contains fields:
pro_name
no_of_comp
inserting data from form where products field is mutiline text box. split this and store in array then insert records.
now i want to facilitate let user edit their data.
during editing new products are entered with no_of_comp = 1 and already exisiting products gets no_of_comp= no_of_comp + 1.
if user delete product then no_of_company = no_of_comp - 1.
what i want to do is: Code:
I have a database feild that I need to have html code entered into. Short of getting the clients the copy and paste code into <textarea>, is there a simple wysiwyg editor to do the job?? or another way?
View Replies View Relatedi try to make three textboxes to enter the date,but the problem is , when they enter the data base they enter like this 10,12,1980. so it will not be accepted by the date field
Code:
<input type="text" name="date" size="2"> <input type="text" name="date" size="2"> <input type="text" name="date size="4">
so how could i exchange the , to / and is there a better way to do the date.
I have a page that pulls 'member' registration information from a table similar to a bulk delete with checkboxes. This works fine, it pulls all of the member info. What I want to do is have the selected records added to a new table known as courses.
Sort of a bulk registration system where I have a list of members, put in the start date, end date, course name and course number once and it populates for all of the members in the new table adding the member info with the course info. Code:
I have a few forms and find that people are intering all sorts of information into them that we dont want. Is there a way to stop people from entering things like ()*&^%$#@!+_=><"':; and so in into the forms.
A form example on the site is basic. Something like this.
<form name="form1" method="post" action="">
<input type="text" name="textfield">
</form>
I have a simple application setup where people can submit a request for a sample of our product to be mailed to them. It's a very simple form with name and address information. I have a page setup where our warehouse guys can pull up current requests and then the plan is to use USPS.com to print shipping lables.
While it's already a big time saver, they're still having to either copy/paste or re-type the information into USPS.com's forms. Knowing the names of the form fields on their site, is there a way I can populate their forms with the data in my recordset from my details page?
For instance, they pull up the current requests and they click into the details page for one of them which lists the person's name and address. If I have the USPS.com page open in another window and on the screen which contains the form fields is there a way to call that page and populate those fields accordingly?
I am building a website to pull data from a remote https site using xmlhttp. The data from the https site is behind a login screen. I can successfully get through the login screen with:
set objXMLHTTP = Server.CreateObject("Msxml2.ServerXMLHTTP")
objXMLHTTP.Open "POST", "https://website.com/validate-login2.asp", false
objXMLHTTP.SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
objXMLHTTP.Send "Username=uname&password=pwd&company=O"
That works great - but then, when I try to go to the next page (where the data is that I want to pull) - I use the same process and I get kicked back out to the login screen? Could there be some cookies, referer, strings being passed normally that I am not including in my second request - How do i find out for sure?
I have used the software IETrace and it looks like some cookies being passed, but how do I know for sure if (and what exactly) it is using?
i have a problem with an asp form on my workplace site. Spammers appear to be hammering it daily with requests, our form sends an automatic email, but the email addresses they enter are all fake "donotreply@whatever.com" which is causing a mountain of repeated mail delivery subsytem messages that run on for days. AVALANCHE!!!
Is there a method of blocking the text "donotreply" in email addresses via validation?
In my page i have two combobox. one for year and one for week numbers.Now my prob is
1.when i select a year from combo box 1, second combox box will display the number of weeks in that year.eg if i select 2005 it display me list from 1 to 53 as there are 53 weeks in 2005.
2.when i select a weeknumber from combobox 2 and press submit button it ll display start date and end date of entered week.
I have a form.htm page where the user enters an ID to retrieve addresses. Then PAGE1.ASP displays the addresses. From here the user selects an address and submits. Then PAGE3.ASP brings back further information. My question is how do I use one field from the address information on PAGE2.ASP to display on PAGE3.ASP? I know how to do it with textboxs and such but cant get RS data to hope page to page. I get no errors or anthing.
On PAGE2.ASP I have :
<input type="hidden" name="CLIENTHIDDEN" value="<%=RS1("CICL_LNG_NM") %>"></td>
On PAGE3.ASP I have:
clientname = request.form("CLIENTHIDDEN")
and to display:
<td class=rt width="110" height="1">Business Name:</td><td width="849" class=rt height="1"><% =clientname%></td>
I want to login to a page using MSXML2.ServerXMLHTTP.4.0 or an object like this, I must send the form variables needed to login when I try to login to the page. But the problem is, that the page looks like a exe file (not a asp file or php file or what ever). The name of the page I try to login is something like "/pw?/session/login", nothing more, without extension. I have tried the code with a normal asp file with session registration and login process and it worked, but not with this file.
View Replies View RelatedLast week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
I'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
View Replies View RelatedWe are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.
THE RESULTS:
(returns a blank page with only HTML Titles)
THE SCRIPT:
(you may notice this is a modified sample script): Code:
I have created a login and members page, and checked that it works, so that when you enter the correct username and password it logs you in.
But how can I have it redirect the user to their own personal page? Because I don't want to have different users going to the same page, I want them each to have their own personal members page.
I've created a site where the user can register and then log in. However if a user registers, the data is entered into the database, but they cannot log in. But a username i entered directly into the database still works when logging in.
Does anyone have any ideas why this may happen?
I get an error like this:
Type mismatch: '[string: "UPDATE dbo.con_users"]'
With the following query code:
UPDATE dbo.con_users SET last_login = #" + nowDate + "# WHERE username = '" + Replace(userUSERNAME, "'", "''") + "' AND password = '" + Replace(userPASSWORD, "'", "''") + "'"
I've successfully tested the variables in it (nowDate, userUSERNAME, userPASSWORD). What is the mismatch?
I've already created a login page .. but how am i suppose to make sure that only those who login can access the member's areas and those who hasn't login will be redirected to login.asp ?? Is it possible to use cookies ???
View Replies View Relatedi am getting log in the application and woring with my some
windows.now keeping that other window open and now from that main window i am
logging out. so it throws me to the login page (as i am logged out). I
am also clearing and abandoning the session. also with the
FromsAuthentication.SignOut().
now with that login page i am relogging with other persons login ID.
Now i am taking the other window which i had kept it aside and now
refreshing it, it is showing me with the rights of the previous User.
I want it to redirest to the login page as it was open by other user
and now that user is not a vlid user as he has logged out.
Im new to ASP and im having trouble building a login script. I need an ASP login that reads the username and password from an XML page.
View Replies View Relatedi have a login page and a page that validates it, if you log in succesfully i want to to display the name of the user on the admin page e.g i want to have "welcome and then the name of the user" how can i do this?
View Replies View Related