got the following sql
Dim varEmail = Request.Form("email")
Dim sqlQuery
sqlQuery = "SELECT * FROM users_tbl WHERE email ='+ varEmail+'"
However this does not seem to work as expected..what am i doing wrong?
I tried
sqlQuery = "SELECT * FROM users_tbl WHERE email =" + varEmail
But this doesnt seem to work either..when i try recieving records from the database it just says unknown column etc error
I have a database driven (ms access) website which runs fine on my computer (win 2000 iis6). However, on uploading, some pages am receiving the following error
"An Unknown script error occured while processing your request."
......
I've got a site with an index page that has been set up to show my latest blog posts from the /blog.html page. From time to time (more frequent than I'd like) when I update my blog, I get the following error:
msxml3.dll error '8007000e'
Not enough storage is available to complete this operation.
/RecentPosts.asp, line 16
I've been told that this has something to do with my hosting company (godaddy) having a problem, but that seems odd to me. Can anyone here give me any ideas? Let me know if you need the URL and I'll post it here as well.
I am getting this error that I have never seen before. Its strange. Everything else works fine. Any Ideas?
Microsoft OLE DB Provider for ODBC Driverserror '80040e10'
[Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect
/ASP/Error.asp, line 56
Here is the code:
I'm getting an http 500 error message, and I can't seem to find where (since it won't give me line-errors). Yes, the host supports asp
Here is the code, maybe you can find an issue? Its not too long: Code:
I am altering an existing asp page,just by adding a new check box, I am going through the code making sure I cover every aspect of the change (there are many check boxes) and situation is exactly the same.'
When I load the page this is the error I get and I don't know why is this appearing,why wouldn't it like a new column, it has been added in the table on the server.
This occurs in my select statement.
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'Invoicing'.
Has anybody come across that?
I am currently working my way through a tutorial from my asp.net book and am slowly getting an understanding how this type of coding works. However, I have come to a standstill with the code below. Code:
View Replies View RelatedI'm getting this error trying to INSERT information into a database. Its saying that the Invalid column name is TicketNum. I have looked at the field name for the database and it is the same.
cnOperations.Execute("INSERT INTO DailyLog (Bancnum, Problem, Solution, TicketNum, CurDate, Operator, InTime) VALUES ('" & Bancnum & "', '" & Problem & "', '" & Solution & "', '" & Tnum & "', '" & setDate & "', '" & User & "', '" & time() & "')")
I have a 3 page set that searches a database for users, displays the user information in a form and updates the data in the database. The first 2 pages work fine, the third page doesn't. What is annoying is that these pages are a copy of another set of pages that edit news articles (basically the same thing) and they work perfectly.
This is ASP with SQL and VB Script.
Quote: Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the varchar value '6, 6' to a column of data type int.
/d1intranet/useredited.asp, line 72
So this message is saying that it is unable to UPDATE the field 'UserName' (which has data type INT) with the variable in the SQL code which is default as VARCHAR. Here is line 72: Code:
i am doing a list of links for a modular website, i was useing a loop
to make a form for the links and link description so that i could have
as menny as i liked and called the text box link<%= no%and
description<%=no%and no goes up each time the loop happens.
my problem is that i dont know how to display them on the next page.
how do i request link(X)? i have been looking at this problem for hours
can someone help?
I have two pages of aspx one is content.aspx and other is framing.aspx
I want that I have 3 diffrent link on my content.aspx
like www.yahoo.com
www.google.com
www.msn.com
and on framing page there are only frame on top my header, on bottom my footer:
but i want that when i click one of the link on content.aspx it must be opened in middleframe of framing.aspx
I have created link using <a href="www.yahoo.com">yahoo</a>
same like this for other 2 .
I have an asp application running with the charset set to windows-1252.Recently, my customer complained about some unknown characters(rectangulars) appeared on the screen.
Later I found out from database that the unknown characters are supposed to be coma (,). I then tried to set the charset in all pages to UTF-8 but it did not solve the problem. I have a problem debuging since my testing machine does not have this problem.Is there a possibility that font selection such as sans-serif can cause this problem?
I am trying to send an e-mail using CDO I get this message when trying to send an e-mail.
I am using the object
Set ObjMsg = Server.CreateObject("CDO.Message")
CDO.Message.1 (0x800C000D)
The specified protocol is unknown.
I want my asp page to upload all files from a certain directory on the client pc onto the server.
Code:
set FSO = CreateObject("Scripting.FileSystemObject")
set F1 = FSO.OpenTextFile(???) -> I only have the directory here
I need to create a script that will collect any variables sent by a form.
Reason: A company that I work for wants to have a script that they can pretty much send any HTML form to that will send them an email with the results. So if they make a new form with different form fields next week, they can point it to the same script.
Is there anything in ASP that can "Just collect Anything/Everything" that is sent from the form?
I have admins who create reports with titles that my code then creates a field with that title in another databse. The admins also apply permissions to staff whether they can see that report or not.
My problem is my code doesn't know the name of these new fields, is there any way in ASP to interegate the access field names in a record set?
I have been writing a photoalbum in ASP and I am trying to receive an undetermined amount of files.
A more detailed explanation:
The client side (Javascript) generates a new file upload box as soon as the file in the first box is selected...the name of the file upload boxes is bestand[] so that the input is received in an array.
Now I am trying to receive all the files with ASP and store them on the server....
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies View RelatedI have a form that is dynamically generated since it is populated with values retrieved from a database. The form can of course also be submitted, which is where I run into some problems.
Since I never know in advance what the length of the form (or for that matter what the different elements' names and values) will be I don't know how to write the code in "receive.asp" to retrieve all values from the form correctly without excess use of "request.....".
I shouldn't have to write requests for every single potential element name that is stored in the DB. Please note that the form can sometimes also contain radio buttons and check boxes, even though they are not present in this short example Code:
Ok my boss wants to know if there is a way to display an unknown # of pics from folder onto a web page ASP using VBScript or JavaScript... doesn't really matter.
You don't know the names of the pics or how many are in the folder just that you want to display all the pictures in the folder...
I have a csv file that I'd like to be able to add a column to. Specifically, I want to take the first 6 chars of the filename and add it to each row as a new column. e.g.
Code:
whatever.csv 'before
1,2,3,4
whatever.csv 'after
1,2,3,4,whatev
Ok let me explain what I am trying to do as easily as I can. I have a table in my access database that I am connecting to. I select a specific id number using my SQL statement. Now what I am trying to do is scroll through that records row and get the column name of that column along with the value of that cell. I hope that isn't to confusing. Now I'm not sure whether this would be done using ASP or done in my SQL statement. Code:
View Replies View RelatedHow do you get the description of fields in an Access database? I really need this and can't find it anywhere....
It would also help if someone showed me how to get the datatype and other info (like if it's a Yes/no or True/False field).
What is the resource/doc for this so I know where to look before asking from now on?
Ok i'm self taught with regards to ASP so not great etc, so sorry if this is a really basic question..
On the last line here i'm trying to some how get it to call the last ID entry...
ImageID = Request("ID")
If (Len(ImageID) = 0) then ImageID = "1"
If Not IsNumeric(ImageID) Then ImageID = "1"
If ImageID = "0" then ImageID = "1"
If ImageID>3 then ImageID = max(Len(ImageID))
This is basically for some max min links for a online comic here's what it links to
<a href="default.asp?id=<%=ImageID-1%>">< Backwards</a> -
<a href="default.asp?id=<%=ImageID+1%>">Forward ></a> -
Code:
Can someone please explain to me why the hyperlinked column headings will sort in Firefox and IE 7 but not in IE6. Code:
View Replies View RelatedI need to set up an HTML table or the like, with 4 columns.
Each column needs to have a header with a FRIDAY (dd/mm/yy) date.
i.e. this weeks Fridays date is 16th Feb, the following is 23rd Feb
etc.
So, I need column 1 to be headed 16th Feb, col 2 to show 23rd Feb etc.
As this week passes, the dates need to move up 1 week, so that next
week, col 1 will display 23rd Feb and so on.
These headers need to change according to the date.
Please can you advise how I best achieve this ?
we have a requirement to freeze the column and row column heading... so that when the user scrolls to the right the first two columns ( I refer them as "row headings") will stay and the remaining columns scroll left and when the user scrolls to the bottom the first row stays ("column headings")and the remaining rows will scroll up.. This can be easily accomplished in EXCEL by freezing the itersecting cell... How can the same be accomplished using HTML tables /ASP code.... Is there any Active X control available that can be used to accomplish the same?Our technical env is ASP and Oracle DB
View Replies View RelatedPretty basic but I cannot figure it out.
Column:
FULLNAME (lname, fname)
Needs to be
FNAME
LNAME
Should split at the comman.I already have all the columns created; just
need to SQL command to make it happen.
I am trying to access a table in a SQL server using ADO in ASP. It works fine in the rest of the site. Here is the code:
View Replies View RelatedIf I have several fields:
a | b | c | d | e
and the original SQL = SQL & " ORDER BY a ASC ".
I want to place links to b, c, d, e to make the table of results to show by ascending order of b (or , c, d, e).
do I need to place an "if/ end if" in the sql or do I put some statement in the paging?
example
a (ORDER BY a ASC)| b | c | d | e
1 | 3 | z
2 | 2 | y
3 | 1 | x
4 | 5 | w
5 | 4 | v
to
a | b (ORDER BY b ASC)| c | d | e
3 | 1 | x
2 | 2 | y
1 | 3 | z
5 | 4 | v
4 | 5 | w
I have a SQL query that produces a table which displays account numbers and the amount owed on those accounts.
the page that displays that table is written with ASP. Does anyone know how can I highlight the rows in the table where account numbers have more than 7500 dollars in amount owed? Code:
im reading from multiple databases, and one restraint is that i must know the amount of columns and the names of the columns before i can display info from the database.my question: can i somehow GRAB or READ this information from each database and then just adapt my Display accordingly
View Replies View RelatedI have an asp page which the user enters a time(e.g. 12:21). I need to insert this time into a SQL Server DB, which has a smalldatetime column.
I have tried everything I can think of (such as CDate, TimeValue, FormatDateTime etc) to convert the time string, into a valid time. However, the insert always try to insert a datetime datatype (e.g. 12/12/1899 12:21:00).
I am trying to process the insert through ado, eg:
objRS.AddNew
objRS("Field1") = strText
objRS("DateField") = dteValue
objRS.Update