Get The Select Statement Without Hex Value Using Post Method

When I use the following to post my value, I got SQL like this:

SELECT+A%2ECMPL%5FFIELD%5FID%2C+A%2ECMPL%5FFACILIT Y%.

How to get the SELECT without those hex value.

<FORM NAME='formname' METHOD=POST
ACTION='ExcelExport.asp?noIncludes=yes'>
<INPUT TYPE='Hidden' NAME='strSQL'
VALUE="<%=replace(server.urlencode(strsql),"'","`")%>">
<tr><td BGCOLOR=E4E4E4 ID='bodytext' COLSPAN='8' align='center'><input
TYPE=SUBMIT value='export'></td></tr>
</form>

View Replies


ADVERTISEMENT

POST Method

Now this is a weird one. I'm having a problem with a system in development. When I post data from a form in IE 5.01 it works fine, but in IE 5.5 it refuses to post the data to the server and in IE 6 it's scatty -- works sometimes but not others. Anyone seen this before?
Edit:
By the way -- this is normal VBS/ASP running on IIS 5 on an NT server

View Replies View Related

Post Method

I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>.

But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Here's my code.

I have a form that ignores my form validation code. My code works if I use the post method of <%=Request.ServerVariables("SCRIPT_NAME")%>. But, If I post the form to another .asp page, which I prefer, the code doesn't work. Do anyone have any suggestions? Code:

View Replies View Related

ASP POST Method Bug

I have a demo.asp page, that can't pass hidden value "mr progrramer" to
itself using POST method. Only "mr" is passed.

I created a second asp file demo1.asp and passed "mr programmer" and whole
string (include space b/w mr and programmer was passed successfully).

The code for demo.asp is:

<%
name = request.Form("name")
response.Write "hello " & request.Form("name")

' if name is empty then store some string with space in it
' problem is the word before space 'mr' is passed, but 'programer' is not
passed
if len(name)=0 then
name = "mr programmer"
end if
%>

Code:

View Replies View Related

POST Method

I have a .asp page that uses the post method and it works fine on my computer using iis. But when i put it on the web server (it has windows NT4) it wont work.

I've read that you have to do something to allow the post method on the server.

i know nothing about windows NT4 but can get access to the server. can someone please let me know what i have to do to get this to work?

Just to let you know the post method is for ssending a login and pass to another page that search a database for the record. If there is another way to do this that does not show the variables in the url please let me know. i am also willing to make it so that everything is on the same page so i dont have to pass anything.

View Replies View Related

Post Method

Is there a limit to how many variables you can pass on using post method?

View Replies View Related

GET Or POST Method

when we should use GET method, when we should use POST method? GET method only sends limited amount of data, and it will show the data as part of URL. POST method won't show the data as part of URL, and can send any amount of data.

View Replies View Related

Post Method

I hv an asp page that allows the users to enter two dates, when they click a button i have another asp page that is opens word and shows the results in a table.

in order to get the criteria i think i need to use the post method for the page that opense word. however i ahve done a search and can not see anything that properly explains this method.

View Replies View Related

POST Method

I'm having trouble reading data that i send to the server using ajax. The call am making in the client-side javascript is:

fullProject.open("POST", url, false);
fullProject.setRequestHeader('Content-Type','application/x-www-form-urlencoded');
fullProject.send('var1=' + projectData);

and I want to know how to grab that data using asp. The call that I've
been manipulating is

<%
response.write "data: " & request("var1")
%>

That hasn't been working, and all I've been receiving back is the string "data: ".

View Replies View Related

Using Redirect With Post Method

how can i (if at all possible) use post with response method? before i always did something like this to pass variables to the nest page:

Response.Redirect "main.asp?per=" & per

this obviously creates a querystring and that i am trying to avoid... so, if anyone knows how to do this please pass it on.

View Replies View Related

Encenctype And Post Method

I'm trying to sent information from a form to the server using the post method. The problem I'm having is that I have a file form field and it reqiures enctype="multipart/form-data". With this enctype, the data from the text fields doesn't get passed to the server. Is there a way around this?

View Replies View Related

Send A Variable Via Post Method

sending a variable in this way: temp.asp?num= <% = Var %> creates an error , although i can see in the url that the value is added (e.g temp.asp?num=3) is it because the method is post? what should i do so the variable will come throgh with no error!?

View Replies View Related

How Could I Use POST Method To Transfer Parameters With XMLHTTP?

How could I use POST method to transfer parameters with XMLHTTP?

With GET all works correct, but with POST I get a problem.

client.asp with GET - all works .....

View Replies View Related

Post Or Get Method To Link To Detailed Information

we have been able to list information about people in a 5 column table coming from the database. Code:

View Replies View Related

Send Post Method Without Need To Click Submit

is it possible to send info to a page with the post method automaticaly ?
whithout the user having to click the button ?

View Replies View Related

Sending Form Data (like Post Method) To A Location Offsite

I'm trying to "post" a form in asp to a script off the main site.

I suppose I could do a response.redirect to the script, but am wondering if there is a more direct way to do it. Something like the XMLHttp obj in js.

View Replies View Related

Select Statement

how do you select all the fields in a table that do not contain any data?? I have tried the below and it wont work??

View Replies View Related

Select Statement

I am trying to display a feild from the table. But there is a Type Mismatch error that I am getting. Can anyone please take a look at my code to see what could be wrong.

The error that i am getting is:
Microsoft VBScript runtime error '800a000d'

Type mismatch

/jobapplicationnew.asp, line 1285
Line 1285 is highlighted.

Code:

View Replies View Related

Select Statement

following is my select statment code, works partially fine but the city search is not working.. i.e it gives me list of all hotels that start with the given words whereas it should give me hotels in the given city only. pls help me out. thanks

sSQL = "SELECT * " _
& "FROM [hotel] " _
& "WHERE hotel_name LIKE '%" & Replace(hotel_name, "'", "''") & "%' " _
& "OR hotel_name_e LIKE '%" & Replace(hotel_name, "'", "''") & "%' " _
& "and city = '"&city&"';"

View Replies View Related

Select Statement

the select statement as per the following relationships:

drop1id has 1 to 9 records.
drop2id has 1 to 65 records - FK drop1id will be 1 to 9
drop3id has 1 to 356 records - FK drop2id will be 1 to 65
drop4id has 1 to 356 records - FK drop3id will be 1 to 356.

I am not sure how to retreive the records based on their relationships.

View Replies View Related

Select Statement

does anyone know if its possible to look through a field in a database and see if it contains certain keywords?

i am using a database with a field called MainIssue and i want to see if it contains keywords and if it does, to display the contents. is there a command which would do the same thing as:

select * from maintable where field contains "keywords"

View Replies View Related

Select Statement

I am having problems with a select statement in asp with an access database.
I pull First and Last information from my form
First = Comes from form
Last = Comes from form
I have validated that the form information is being pulled this is where my problem lies.
Code:
SQL = "Select Listing where (FirstName =" & First & ") AND (LastName =" & Last & ")"
For some reason I can not pull the information for the database using this. If I take the AND (LastName =" & Last & ") out I can pull some of the information, but I am looking for a specific last name, first name entry.

View Replies View Related

Select Statement

i have the following tables in my Access database

info1, info2, info3...

all tables have the same columns with the same type of data.

code, description, activated etc.

now i ask the user to enter a code, and then it searches through all the tables for that code. the reason i broke it into smaller tables is there is 10s of thousands of records.
it should find the record that match with the entered code and then if the user wants to, he can edit the data, the date is then automatically saved into the record as well.

View Replies View Related

Select Like Statement

Some of my pages include paging where the variable starts with a certain letter. This worked fine in access but when I try to run it with mysql it says...

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[MySQL][ODBC 3.51 Driver][mysqld-4.0.17-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT username, status FROM users WHERE username Like 'A%' OR

View Replies View Related

Select Statement

This is really simple but for some reason no recordset is returning. I can't get cat_1 to write. I have run the query against the database in Query Analyser and it runs fine.

Code:
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString = "Driver={SQL Server};Server=nzlakldwhse;Database=Complaints;Uid=elkuser;Pwd=elk;"
objConn.Open

Dim objRS
Dim cat_id, cat_1, cat_2
set objRS = objConn.Execute("select cat_id, cat_1 from complaints.dbo.category a where a.cat_id = '"& request.form("cat_id") &"'")

response.Write(cat_1)
response.End

View Replies View Related

Select Statement

Code:

[advsearch = "Select * from img_inv where item_num like '%" & item_num &"%' or category = '" & category &"' order by item_num"



I want it to be able to search the db by like item number or exactly equal it a given category list.

View Replies View Related

SQL Statement Select

How do i get this to work, i have 3 colums forename, surname and groupname and a colum Genre. I want to select any of the 3 first colums for a name, where the Genre colum is X
this is the statment i have
Code:

"select * FROM autos WHERE forename LIKE '" & session("name") & "' OR surname LIKE '" & session("name") & "' OR groupname LIKE '" & session("name") & "' AND genre LIKE '" & session("genre") & "'"


this is what i get :-
select * FROM autos WHERE forename LIKE 'david' OR surname LIKE 'david' OR groupname LIKE 'david' AND genre LIKE 'Football'
giving David and 'session("name") and Football as session("football")

View Replies View Related

SELECT Statement

I've inherited a database with NULL values in it. I plan on fixing this problem, but for now I need to get this statement working.

cmd = "SELECT * FROM EmpInfo WHERE Interview <> NULL AND status IS NULL OR status <> 'D'"

I'm trying to pull information from the table that need to conform to two different rules. First, there needs to be a value in the INTERVIEW column.

Second, the column STATUS has to be NULL, there can be no D (for delete) in the record.

I can get it to pull the records following the conditions for STATUS, but not for INTERVIEW. I don't work with NULL values very often, so this one is throwing me for a loop.

How can I write that statement to pull only those records that are not NULL in one column, but NULL in another?

View Replies View Related

SELECT Statement

In my company one of the people who works for me has done this:

sqlText = "SELECT products.ProdID, productName, " _
& "productPrice, quantity from products, " _
& "itemsOrdered where " _
& "products.productID = itemsOrdered.productID "_
& "and itemsOrdered.orderID = " & intOrderID

I am just a little unsure what products.ProdID means when later on in the string there is the FROM products?

View Replies View Related

Select Statement

i give the users the option to choose between a daterange to get data from the database.

For example
(RADIO BUTTON) Last 7 days
(RADIO BUTTON) Last month
(RADIO BUTTON) Custom dates

Got the custom dates part to work, but how do i write my select function to select todays date and then go back seven days / 1 month(30days)?

View Replies View Related

Select Statement

In a select statement How do i select the last 10 records in a database?

View Replies View Related

Select Statement

I've got a client who needs some ASP's coded for a Unix server running ChiliSoft, (I had no say in the matter).

I'm banging my head against a wall with the following code:
[VBS]Set objRs = Server.CreateObject("ADODB.Recordset")
Set objRs.ActiveConnection = objConn
objRs.Open "Select * From tblDataBank_Summer Where DatabankID = " & intDatabankID, , adOpenStatic, adLockOptimistic, adCmdTable[/VBS]

I've used this coding elsewhere on other sites with no troubles, but here I keep getting:

ADODB.Recordset.1 error '80004005'

SQLState: 42000
Native Error Code: 1064
[TCX][MyODBC]You have an error in your SQL syntax near 'Select * From tblDataBank_Suummer Where DatabankID = 114 ' at line 1

View Replies View Related

Select Statement

how to do a select statemtn like below

SELECT * FROM table WHERE ID =" & strID & " AND Users LIKE " & strUserName

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved