j0rdanf1
Last Activity: Mar 12 '08, 01:49 PM
Joined: Oct 31 '06
Location:
-
You are a legend, thank-you my friend that has solved a big problem... -
great, but how would i attach the Ucase() function to the requested code?...Leave a comment:
-
lower case to upper case
hi people,
I have rather an odd question, all the information I have inputted into my aql database is lower case, however, on some of the pages i display i want to retrieve the code in an uppercase format, is their any straight forward way to do it?
Cheers,
...Code:<% Dim strbasicsearch, strSQL, objConn, objRs strbasicsearch = Request.QueryString ("basicsearch") -
request form error
Hi,
I have been working on this for 2 days now, basically I need a front end to edit some data in oracle. Though everytime i pass the info between the pages i get
...Code:Band Name: ADODB.Field error '80020009' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /user/edit_band.asp, line 0
-
im using oracle mate...Leave a comment:
-
search bar problem?
hey, I have just ventured into the fun world of creating a search bar, so far i have a page which you type in a name of a band or album you like, the next page is meant to connect to the sql database and find matches that are LIKE the text entered. However I get an error instead.
ERROR code
...Code:Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Oracle][ODBC][Ora]ORA-00933: SQL command not properly
-
its ok came up with a solution, cheers though...Leave a comment:
-
Thanks mate, it was the server at fault, cheers for everyones inputLeave a comment:
-
still having trouble with this, I have no idea if its possible or not. :s
I would have thought it would be quite simple, if the user has never logged on before thier should be no cookies recorded meaning they see the logindex.asp script in the top left, if they have logged in before the cookie should still be present and therefore load the welcome user.asp script showing their email address.Leave a comment:
-
cookies and IF's
Ok, so I thought I would try and be clever, i wanted the space which usually has the login form to change once logged in, however when I try it out nothing appears in that space. Im a tad confused, any ideas?
...Code:<%@LANGUAGE="VBSCRIPT"%> <% userid = (Request.Cookies("login1")("userid")) If userid = "" Then <!--#include file="welcome user.asp" -
Thanks mate, I will give it a go and post back here, either way I am seeing the server team on thursday to have a quick chat about it.
Cheers...Leave a comment:
-
According to the oracle server, it states the connection is ok? maybe best check with the server team,
though does the script look ok, no obvious mistakes?...Leave a comment:
-
VB ASP form
Hey,
I have been working on creating a basic login for a website now for 2 days and still have gotten no further.
So far I think the form is correct, it has to fields a username and a password field, this then gets submitted to the check.asp via the post method then the vb script is meant to link to the sql database and validate if the login information is present in the database. If it is redirect to welcome.asp, else... -
After messing about with this nearly all of today im still no closer but im 100% sure its not a fault on the form part, its got to be the next step, is the code wrong?
...Code:<!--#include file="Connections/connect.asp" --> <% userid = Request.form("userid") password = Request.form("password") strSQL = "SELECT * FROM login WHERE userid = '"&userid&"'Leave a comment:
-
Thanks for the quick response, my login.asp page his this form, it seems ok to me it attempts to goto the next page but gets this message:
res://ieframe.dll/dnserrordiagoff .htm#ftp://username:password@129.110.11.182/check.asp
form on login.asp
--------------------------
...Code:<html> <head> <title>login</title> </head> <body> <form
Leave a comment:
-
Login form asp
Hi I have been asked to create a simple login form for a website and due to the lack of knowledge im struggling, so far I have a form which posts the information to the check.asp section
<% @language="vbsc ript"%><%
'#Connect to SQL database#'
Dim objConn, objRs, strSQL
Set objConn = Server.CreateOb ject("ADODB.Con nection")
objConn.Open "dsn=Oracle;uid =user1;pwd=pass word;"... -
Anybody? tried to google the answer but am not really getting anywhere...Leave a comment:
-
Tried the one for the query and received this error
"Data Type Mismatch in criteria expression"
the above code matches the table called MACHINE and matches the cell Warrenty Finish so it confuses me a little.Code:IIF([MACHINE].[Warrenty Finish]<=Now(),"Finished","Not Finished")
This is the format i use in the Warrenty finish cell 19/09/2010
Ch...Leave a comment:
-
Help With Report
I think after this question i may have to invest in a book,
I have a report where i want to show the date of all computers that have expired if its equal to todays date or before.
So I have created a query to show the results i want, now i know all i need to do is input a piece of code into the criteria of the expiry date. The question is what code do i need.
A rough but wrong guess of mine was
... -
No one have any ideas?...Leave a comment:
No activity results to display
Leave a comment: