Create Table With Username And Write To It With Results From Form
I have an asp page that gives results for a search from a previous page from streetguide.streets in MySql. The page displays the UserName of the person logged in.
I have the results of this query displayed inside a form with hidden variables. When the user clicks "save to my folder" I want it to create a table in the mysql db with the same name as the user name, and then write to this table.
I have it working if I created the table beforehand, but I want the table to be created dynamically upon form submission with the table name to match the persons user name.
View Replies
ADVERTISEMENT
Here's what my code looks like...
View Replies
View Related
I have a login page that's preset where the user type in their username and password. What I want done now is make the user create his/her own password on first visit to the web page. For example when the user tries to view a specific page on the site he/she is prompted: " You must first create a username and password to access this page". This is my login script, how can I change this to prompt the user on first visit to create a username and password?
View Replies
View Related
Anyone knows how to create the username/password authorization dialog in ASP?
View Replies
View Related
I have a record set that I can successfully write out to an asp page.
My manager would like the reports to have alternate row colors for the
report tables (i.e. rows 1, 3, 5, 7, 9, etc have white background and
rows 2, 4, 6, 8, 10, etc have a green background). Any ideas on how to
do it? I am sure it has to do with the *tr* tag, but not quite sure how
to work it.
View Replies
View Related
I am trying to write out the results to the screen and save them to disk, but I can't figure out how to properly formulate the code.
I keep getting this error: Object doesn't support this property or method
Code:
View Replies
View Related
i have a select statement,
Code:
<%strsql2="select * from [Contract Status - Topline] WHERE CPN=86482 AND date = '" & demodate & "' "%>
set rs2 = sqlconnect.execute(strsql2)
then i have a insert statement
Code:
View Replies
View Related
I am trying to develop a little site for myself an co-workers to enter
our march madness bracket picks. With the tiny little bit of knowledge and
some cutting and pasting I have created a mess that sort of works.
I have a JS form that users can enter all of their own picks. However, when
the picks are entered into my DB the only appear as numbers. There is an
area in the code that refers team #'s but it doesnt quite match what I get
in my dB for instance - kentucky should be 1 and it shows up as 0.
Here is the code - if anyone can throw some tips my way I would really
appreciate it. I have edited out the actual Javascript and the .css styles
and other things that arent applicable (I hope) for easier reading. Code:
View Replies
View Related
looking for code to write a seuqence of numbers to a table in access. user selects quantity to populate, lets say 50 . so the table would need to be populated with the first number of trackid0001 up to trackid0050 through the script
View Replies
View Related
what would be the best way to response.write a table in asp? mutilple response.writes?
View Replies
View Related
I know I can Create Tables In a database with the CREATE TABLE sql statment, but I don't exactly know the syntax of the statment.
I want to add a table with a sertin feild that has a default value, is that possible?
The syntax I know is:
sql = "CREATE TABLE tablename(feildname FEILDTYPE,feildname FEILDTYPE...)"
Are there any other parameters that I can add to the statment?
View Replies
View Related
I'm writing an ASP app to create a table in an MS Access database. I use:
Code:
sql = "CREATE TABLE success(name text (50), company text (75), article memo (), img text (50))"
and get a syntax error. When I remove the "article" field and param, it works. Even when I add a max char param inside the parenthesis
Code:
article memo (255),
I get the same error. Doesn't the "memo" data type allow unlimited charactors? If so, is there a param that I need to add to the memo () call?
View Replies
View Related
how to tell access to allow a zero length and put a default value now() in the date/time field in SQL?
View Replies
View Related
how to create new table which the table's name is variable. for example: i want to create table with the name is come from user's input in the form input.
create table <table's name variable> ( ...
View Replies
View Related
Can you create a table in an access database using create_table?
View Replies
View Related
Code:
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("mydb.mdb"))
'conn.Open "DSN=Survey"
Dim strSQL
' Creates a table called survey3
strSQL = "CREATE TABLE survey3 (Q1 text(20),Q2 text(20));"
conn.Execute strSQL
%>
This code works..But before I create the table I need to check if it exists and only if it doesn't i want to create it...How can i do it?
View Replies
View Related
I need to create a new table in an Access Db for a Db driven Classic ASP website. My concern is that if I alter my local copy of the Db and then simply upload it, data might be lost if any of the users are logged in and posting stats.
Is there a way for me to write and execute some code to add to the Db? In PHP I usually use sql statements with the PHP MyAdmin interface, but I don't know of such a thing for ASP-does it exist?
View Replies
View Related
I'm trying to figure out if this is possible before i have someone start scanning a bunch of images.
If i scan a bunch of images and give them specific names can i then look at that dir and read the name of the file and write a link in a field of a table?
example
FOLDER CONTENTS
123254.jpg
125684.jpg
168468.jpg
TABLE record example
epn =123254
name = Bob
Picture = 123254.jpg
i want the name of the file to be written if there's one in the folder for that epn.
View Replies
View Related
I have a form that i'm using to collect a NEW users username, password, confirm password and email address.
I cannot seem to grasp the concept of the various ways to "validate" these fields. Here is what i'm needing.
*Username field is required (cant be left empty) and doesn't match any current username records - I do have the form going to a page that does the SELECT WHERE blah blah and has the rs.eof thing but I'm not sure how this is fitting into the part where we make sure its not blank. Also when there is an error, I was hoping it would redirect them back and leave the "correct" data in the spaces. Mine seems to empty every last field even the correct ones. Is there a way to only change or blank out the wrong fields?
*Password required (cant be left empty) and both fields match.
I have something like this so if they do match, it continues on ....
View Replies
View Related
I am having a problem using the SQL statement "CREATE TABLE" for an SQL Server database. The code works right in Access but when it did not work in SQL Server 7, I changed some of the datatypes to match an SQL Server 7 generated script. The problem is, it still does not work!
Now the first comments will probably be something like, "make sure your SQL user has permission," or, "make sure your connection string is correct." I have already tested that - the connection string works and I used the DBO (sa) user. Code:
View Replies
View Related
I am trying to use asp to create a new table in an existing database and I keep getting this error:
Microsoft JET Database Engine error '80040e14'
Syntax error in CREATE TABLE statement.
/install.asp, line 75
What would cause this?
Here is the code I am using:
Code:
cnn.Execute("CREATE TABLE crosssale (prodID "&txtcl&"(50) NOT NULL,related "&txtcl&"(50) NOT NULL, PRIMARY KEY(prodID,related)")
By the way txtcl equals:
txtcl = "TEXT" 'access
or
txtcl = "NVARCHAR" 'sql
View Replies
View Related
In the same way that you can create and alter permanent tables in Access 2000 using SQL in ASP ( CREATE TABLE <tablename> col_1(col_1 datatype), col_2(col_2 datatype....Col_n(col_n datatype)) is there any way to do this for Queries?
View Replies
View Related
how do you create a table in MS Access from with an asp script? I will be creating the table name from Request.querystring("name"), also needs fields of branchname and branchcode. guess something like CREATE TABLE & Request.querystring("name") branchname. branchcode.
View Replies
View Related
how do i create a td for each field in my rs, with out labeling them. this is what i have, not sure if i'm heading in the right direction or not.
Code:
<table>
<tr>
<%Do while not rs.eof%>
<td>
<%= rs ('insert rs name'<<<<???)%>
</td>
<%rs.movenext
loop%>
</tr>
</table>
View Replies
View Related
I have MS SQL Server as database. i want to create a new table in the DATABASE, through asp script, naming table's name and naming the fields with their data types.
Can i do this through an asp script, like it can be done through Database tools like Enterprise Manager??
View Replies
View Related
I am new to asp. I am trying to setup a log-in screen and am having trouble figuring out how to set the session cookie. I found the bit of code below, and it works if I enter a specific 'email' and 'password' into the "if" statement, however we have multiple users logging into the section. How can I set it up so that if the form is successfully submitted using any of the multiple email/password combos then it creates the session?
Example found...
<%
Username=Request.Form("email")
Password=Request.Form("Password")
If email="emailaddress" AND Password="password" Then
Session("Loggedin")=True
End If
%>
View Replies
View Related
How can I loop through the values of one MSACCESS table to display the related records from another table? I have one table with two single field records. The values are 4 and 9. These fields are related to another table which contains records that belong to either 4 or 9.
I want my web page to display a table for all records belonging to 4 and then another table of all records that belong to 9. I could specify either 4 or 9 in different record collections but the 4 and 9 could one day be 1 and 5 and I don't want someone to have to get into my code to change the 4 and 9 to 1 and 5 in my sql queries. Any advice?
View Replies
View Related
I need to do a simple but complex thing...
For every record is my users table, I need it to creating a record in 3 tables, with one value (all the same)...
So, in detail:
1 users table
Need to create a record in 3 other tables with the userid from the record it added...
e.g.
From record 1 in Table A, create a record in Table B, C, and D with the value of field 'userid' the value of the 'userid' field from Table A...
Get it?
View Replies
View Related
I'm trying to dynamicly create a table in an existing ACCESS database. Code:
View Replies
View Related
I have been looking everywhere, and can't find a complete function to create tables and columns in access .mdb from ASP, while adding columns that are missing in tables that already exist, can anyone post a link or the code to such function?
View Replies
View Related
I am in the process of rewriting my table formats for an Access Project that was created. I now need to get the data from 1 table and transfer to a second table.
I created a page that creates the record set, I then loop through that record set and need to run an update statement to a second table, however, I get the following message:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/BusPlanTest/updBusPlan.asp, line 17
Below is the code I am using: Code:
View Replies
View Related
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies
View Related
I have programmed several online forms(typically using cgi).A client of mine does not like how the results are formated (the long column of text)Is there anything I can do to program the results of this online form to get put into another format that would be e-mailed to the receipient?
View Replies
View Related