Pulling Info From Database According To ID
Im getting this error message:
Microsoft JET Database Engineerror '80040e07'Data type mismatch in criteria expression.
Im passing a ID value to a pop up window attached to a variable named 'cat'.
Its passing it across fine, but the following code doesnt seem to be working in relation to it:
strsql = "SELECT cat_ID, art_Artist, art_Title, art_FDescription, art_Price, art_PicFull " &_
"FROM eventDisplay WHERE cat_ID='" & cat & "' "
can anybody see what im doing wrong here?
The following code:
View Replies
ADVERTISEMENT
I am working on a site where you must log in to access the site. On this site we have a link to an off site that needs a user name and password to access it. We have made the user names and passwords the same for our site and the offsite.
the thing that we are doing is when they click on the link to the off site we want to pull thier name and password form a data base (which is already made) and input it into the user name and password.
I am not sure exactly how to code this to pull the name from the data base.
I as of right now have it HARD CODED with a user name and password and it works. But I need to some how have it pull the "correct" name and login.
I work for a smaller Insurance firm and these names are for our reps. We can not have just anyones name getting pulled from the database due to each rep is working on differnt cases. Code:
View Replies
View Related
Here's my scenario: I send an email to my customers which contains an embedded URL with a recordnumber within it. What I want to do is create a variable for the recordnumber, write a select statement against my database using the variable as the argument for the WHERE clause, and display the results of the SELECT (its always a single value) within an HTML page.
Here are snippets of the code. The recordnumber is represented by strCallID and the resultset that I'm trying to display is strATG (shown near the bottom of the HTML)
All the connection string stuff has already been taken care of, so that's not included in this code:
View Replies
View Related
I have a two pages. The first is a data entry screen (which saves the form data to a DB) and the second page displays the text that was inputted on the previous page( pulled from DB). Is there a way to insert <%=date()%> into one of the text areas and have it
be processed on the second page when that text is pulled from the database?
View Replies
View Related
I have an access database that holds among other info, web addresses and email addresses. They are in a hyperlink format in Access. When I run the ASP code, they disappear. I want to pull the data out, with the web addresses as hyperlinks.
View Replies
View Related
I have an access database from which I am pulling records. The main table contains all the info for a specific person and their business. I am retrieving the data and sorting based on last name, and I am also retrieving and sorting the data based on the specific region a person is in.
What I would like to do is also sort based on a sector that a person’s business is a part of. I would be able to retrieve all the records for each sector and sort them just as I did with region, but I don’t want to list ALL the sub-sectors. Code:
View Replies
View Related
I am trying to learn how to retrieve information from the database. I am not too familiar with ASP but I was told to use it. How do I go about doing this? What specific aspect of ASP do I need to learn?
View Replies
View Related
I have made a registration form for adding my friends information in a
database. The problem is that I want to connect the persons with companies
in the same database. I wonder how i could connect a person to several other
id's in a table.
I wonder if I can make a string in the database that holds all the id's
separated with , for example....?
the string would then look like this:
1,4,6,22,56
for example...
But how can I then open this string and separate the numbers from the , ???
View Replies
View Related
I have a form that when the user inserts the password data it is supposed to update the member info in the database with the password but instead it just adds a new row with the password and leaves the id requiring the password blank. SO it does add to the database but just not in the correct row.
Here is the code that I have:
View Replies
View Related
i have been trying to get info from a form into a database on the server for months, i have one form page and one asp page that should send the data to the database on server heres is my code for both pages. here is the form page:
<form action="deantest.asp" method="POST">
<input type="text" name= "name" ><BR>
<input type="Submit" value="Submit">
</form>
and here is the asp page with the code that i use to put the form data into the data base.
<%dim strformfieldvalues
strformfieldvalues =request.Form("name")
response.Write ("your name is ") & strformfieldvalues%>
View Replies
View Related
I'm trying to update a database from a form, but only by updating the info that was changed on the form (if that makes sense.) Basically, the problem I am having it that the if statements I have setup to build the sql isn't working when the database doesn't have any info in that field. Code:
View Replies
View Related
I have a database on my server that houses information regarding trouble tickets. I know how to write asp page to take the inputted info from a form and put it in the database but what I would like to know if someone could show me or point me in the direction of a good tutorial that shows me how to list all the content in my database on a web page.
For instance I would have a page titled, view all tickets, then on that page would be a listing of all the tickets and their information with buttons to add, delete or update ticket.
View Replies
View Related
I can display information to a webpage from a database and handle the connections etc. My next task is a bit more complicated for myelf. Id like to have a page the pulls information from a record set and displays like this.
down one side
the container numbers
along the top
the products in the containers
the information in the middle would be the amount of product that came on that container.
Im just wondering how the best way to setup my database would be, and the best way to setup the asp webpage. (oh) nearly forgot, it has to repeat the information till all the records are finished but i guess that gos without saying.
View Replies
View Related
I have a table in an Access database that is called news. Inside that table is a field name called newsNews. I'm trying to get that is in that field to display on a page and her is my code:
View Replies
View Related
Im doing a login page for my website, and it seems i have to do this:
'Database connection info and driver
strCon = "DRIVER={Microsoft Access Driver (*.mdb)};uid=;pwd=letmein; DBQ=" & Server.MapPath(strAccessDB)
What the hell is that? Do I just put the physical path of my DB in there?
View Replies
View Related
I'm trying to pull the last 5 records from my database.
<% j=5
rs.MoveLast
While ((j>0) AND (NOT rs_article.BOF))%>
''Execute HTML and data insertion here
<%rs_article.MovePrevious
j=j-1
Wend%>
Everytime I attempt to run this code, I recieve an HTTP 500- Internal Server Error. It tells me no more than that. I know that my connection settings are OK because when I move forward through the database (first five records), the code executes without error. And yes, my Cursor type is Dynamic.
Alternatively, I would also like to know how to add new recordset to the beginning of a database rather than the end.
View Replies
View Related
Except for extremely basic ASP programming that I did two years ago and have forgotten I have not touched coding since!
I've taken a look at a couple of tutorials but they all baffle me!
Can anyone tell me how I can just create a simple html form with input fields of FirstName, LastName, Email and Phone amd when the user hits submit it is recorded in an access database?
I can do the HTML part fine. And I believe I've set up access ok although Ive never used it before.
Also, if the server that the database will go on is a Microsoft one i suspect that is ok? Im not sure if all i have to do is upload the database and it will work? or do i need to talk to my hosting company to set up some kind of odbc thing that ive heard about?
My database will just be called clients.mdb and the table is called Customers.
View Replies
View Related
if I have a list of book names and prices and I just want the info to be called onto an HTML page to be displayed how would I do that?
It sounds easy...but who knows with code? :P
I havent' set up the database yet but i suspect it will just be called books.mdb and the table will be called Books.
Fields in the table will be
Name, Type, Condition, Price
View Replies
View Related
Code:
while (!MyQuery.EOF){
Response.Write("<tr><td colspan='2' class='results'>" + MyQuery('Title') + "</td>");
Response.Write("<td align='right' class='results'>£ " + MyQuery('Price') + "</td></tr>");
MyQuery.MoveNext();
}
I have that returning a record set to display ! I then need to make it so the "Title" is a link to a page with all the information shown for that book! How would i go about doing this ?
View Replies
View Related
I have two forms, one on each page. The user fills the first, then the second, then on the third page all the information is displayed for the user to make sure thats what they want to send.
Then they click submit on the third page and it goes through a database and depending on which category, state and county the user selected it will email all the information displayed on that third page to all the emails in the Email field in the database.
Now, I already have the first and second pages(easy enough) and the third page I can get it to display all the info how I want it and now I need to know how to go about emailing that info to the emails that match the specific fields? Right now all I have it doing on the third page, instead of submitting it for emailing, it just displays the info from the forms AND emails that match from the database. Code:
View Replies
View Related
I have a login script up and running and i have used a session variable to greet the user when they successfully login. what i am trying to do now is create a query to select other information from my database using the session variable, their username. i have been trying all sorts of different things and just cant get it to work.
I know that i have to do a select * where users = session variable(username)
but i dont get where in the code i put it... Here is the code of my protected page: Code:
View Replies
View Related
I am working on a project involving pulling information from Active Directory (Name, email address, contact no.) and sticking this information in some SQL tables. Using ASP, How do I enable windows authentication (username and password from active directory) ?.
In other words, when the incharge user wants to login to the tables on the web, he must use his/her windows username and password ? On the same project, I want to assign different groups with different security levels. (something similar to the Active Directory security groups), and let the admin asign rights to each group in order to control access and privilege of each user within a group.
View Replies
View Related
I came across a topic regarding joining three tables, but couldn't apply it to what I am doing. I have three tables: Accounts, Reservations, Invoices. My goal is to put together a statment for each Account showing all outstanding Reservations and Invoices in chronological order.
Both Reservations and Invoices tables have their own date fields (Reservations - actual date of service, Invoices - date when invoice was created).
so basically Go through Accounts and then for each account that has either UNPAID Reservations or UNPAID Invoices populate a list of transactions where Reservations. ServiceDate and Invoices.CreatedDate should be listed in one column and sorted chronologically.
View Replies
View Related
In have a CSV with 50 entries all are:
FirstName,LastName,UserName
I have a VB script that specifies were to put (in form) each field. So how would i select parse) it?
View Replies
View Related
I've created a form where the user should be able to select an option, then a second list will be populated based on that selection. The next part is where I am running into trouble.
The user can also select a time window which can limit their search, if they so choose. Code:
View Replies
View Related
The end result of what I want is to display news headlines for specific stocks on my website. I adapted the below code (very unsuccessfully) from pulling data points from yahoo to news headlines. Code:
View Replies
View Related
Say I want to sort the data in both db's according to similiar properties and read the results in a table.
View Replies
View Related
I have a database that has an email column that either contains an email address someemailaddy@mail.com or a value "n/a" All I want to do is loop through the column in ASP by checking to see if the "@" is in the address and if it is feed the email address into a mailto: href tag . I think something is wrong with my code because it just returns the name but not the href.
<% IF InStr(1, contactObjRS("Email"), "@") = 1Then %>
<a href="<A href='mailto%=contactObjRS("Email'>mailto%=contactObjRS("Email") %>"><%=contactObjRS("FirstName") %>
<%Response.Write(" ") %>
<%=contactObjRS("LastName") %></a></font>
<% Else %>
<%=contactObjRS("FirstName") %>
<%Response.Write(" ") %>
<%=contactObjRS("LastName") %>
<% End If %>ted.
View Replies
View Related
Is there a way to pull the auto-number of a row entered into a database? IE, if I create an order, automatically pull the order_no from the order_table so that I can insert it into an order_detail table. There has to be a better way then selecting max order_id because that might not be the most current order? I know there is a buiilt in function in php what about asp?
View Replies
View Related
we just migrated to Windows Server 2003 and active directory. On our intranet I would like to personalize some of the pages my users hit. Let's say I login as petertom, when I go to my main page.
Is there a way to grab information form the fields in AD after a person authenticates? Is there a timeout, i.e., user logs in at 8:00 AM, but doesn't hit the intranet until 1:00 PM etc?
Eventually I would like people to get to secure areas without needing a login and password, but based on what AU or group they belong to, is this possible as well? Does any of this require changes to be made via IIS? (The intranet is running Win2k server, not Win2003).
View Replies
View Related
I need to pull dates (years) out of a string. The string can either be a date range like "The date is between 1975 and 1978" or a single year like "The date is 1980".
View Replies
View Related
i am having to write a password protection script that pull the user info from the user accounts on the server. so, that way people within the company can log on using the same user name and password as they would to log on to there computer/the network. any ideas? i will also have to give each user different permissions, but i think i can figure that part out.
View Replies
View Related
I have a set of db results that I cannot filter completely in my query and I'm trying to figure out how to eliminate the "duplicate entries" after the fact.
My problem is I'm pulling columns for lot number and transaction time, but some (not all) lot numbers have two transaction times so I can't filter out these double entries with a "DISTINCT" statement in my query since the transaction times are distinct, but I only care about the first one. I'm looping through pulling my results as such: Code:
View Replies
View Related