|
|
When you post variables to a server via a FORM you normally do...
<FORM method="POST" action="index.php">
</FORM>
Once that form is submitted either directly through someone clicking on a submit button or indirectly via a function call to submit() when using PHP or ASP why does the URL always change to reflect the script that just got called?
Perl doesn't appear to require you to do this. It let's you POST and no page refreshing seems required. Does it work this way? Is it becuz PHP/ASP send HTTP headers with every request and in Perl it's up to you to compose your own headers?
What I really want to know is (prolly wrong site to ask) how can I submit form data to a server but not have the page redirect, like i've seen Perl/CGI scripts do?
The technique i've used so far was to just redirect back to caller script as quick as possible, but it's still noticeable and I don't desire to have it be noticeable.
If I use Perl to process the form data and store it in a database, does the page still need to be redirected?
Thanks
The word of the day is legs, let's go back to my house and spread the word
|
|
|
|
|
well u can add the processing logic at the top of the form and only execute it when a certain hidden form field is set (one that u add for this purpose) ... u are always going to get a refresh when u redirect to another url (which is what a form submit does) but i have many web apps that do this and u dont see anything change
"there is no spoon" biz stuff about me
|
|
|
|
|
I'm not quite sure what you mean -- I use both Perl and PHP in my webapps, and they really boil down to similar methods of operation.
- Mike
|
|
|
|
|
You can always add a target to your tag to have the page "post" to a hidden IFRAME.
example:
....
....
....
onwards and upwards...
|
|
|
|
|
When ever I have an apostrophe in a SQL statement, then there is always and error. Sometimes I have to add something like brendan's to a field. I am using an Access database. So a simple statement would look like...
SELECT User_UserFriend FROM tblUser where User_UserFriend = 'brendan's'
|
|
|
|
|
Replace the Single Apostrophe (') with two apostrophes ('').
SELECT User_UserFriend FROM tblUser where User_UserFriend = 'brendan''s'
|
|
|
|
|
The string brendan's is going to come in from a textfield. I can't tell the user to add to apostrophes everytime. Is there no other way of bypassing this?
|
|
|
|
|
Assuming the user input from textbox is stored in the string-variable "userinput":
in ASP (VBScript) do this:
SQL = "SELECT User_UserFriend FROM tblUser where User_UserFriend = '" & Replace(userinput,"'","''") & "'"
in ASP.NET(C#) do this:
SQL = "SELECT User_UserFriend FROM tblUser where User_UserFriend = '" + userinput.Replace("'","''") + "'"
|
|
|
|
|
Thank you.
Would you mind looking at my other SQL problem that I have posted on the site.
|
|
|
|
|
Use a parameter.
Assuming we're using VB[Script] and ADO:
Dim cmd As New ADODB.Command
cmd.CommandText = "SELECT User_UserFriend FROM tblUser WHERE User_UserFriend = ?"
cmd.Parameters.Add cmd.CreateParameter("FriendName", adVarChar, 40)
' Set cmd.ActiveConnection before doing this
cmd.Execute ADO then does any escaping necessary, or passes the parameter directly to the underlying provider.
|
|
|
|
|
I want to check if the user name and password exists in the database. Table name is tblUser. User name is brendanvogt, and password is for example codeProject. I have a problem in that I can type codeproject in capital letters, and it will still accept the password. I can write a mixture of capitol letter and small letters, and it still accepts the password. I tried using the LIKE keyword, and it still does not work. Here is my SQL statement. I am using an Access database.;)
SELECT User_Username FROM tblUser WHERE User_Username = 'brendanvogt' AND User_Password LIKE('codeProject')
|
|
|
|
|
Try this one:
SELECT User_Username FROM tblUser WHERE User_Username = 'brendanvogt' AND strcomp(User_Password,'codeProject',0) = 0
|
|
|
|
|
Thanks, will try it at home later.
|
|
|
|
|
gninneh wrote:
strcomp
SQLSERVER 2000 gives me an error stating this is an unrecognised function.
I was born intelligent Education ruined me!.
|
|
|
|
|
For SQL Server 2000, you can specify a different collation for the comparison:
SELECT
User_Username
FROM
tblUser
WHERE
-- Username is case-insensitive
User_Username = 'brendanvogt'
AND
-- Password is case-sensitive
User_Password = 'codeProject' COLLATE Latin1_General_CS_AI
Or, you can specify a different collation for the column:
ALTER TABLE tblUser
ALTER COLUMN User_Password COLLATE Latin1_General_CS_AI
To get a list of available collations, execute:
SELECT * FROM ::fn_helpcollations()
On earlier versions of SQL Server, or other databases, the simplest approach would be to return the password from the query, and perform the comparison in your ASP code.
HTH,
Richard
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
Can anybody help me how to pass variable values from one page to anothe rithout Querystring. I have dynamic database from which vaues are captured through a menu. I am trying to pass values in each row of the menu when user clicks a choice to another page.
|
|
|
|
|
3 choices
1) Query string
2) POST
3) Cookies
The word of the day is legs, let's go back to my house and spread the word
|
|
|
|
|
4) Session variables
5) Hidden INPUT form fields
Heard in Bullhead City - "You haven't lost your girl - you've just lost your turn..." [sigh] So true...
|
|
|
|
|
Hi all,
I m going to develop a site that is having lot's of category/sub category and different products. For example, www.amazon.com,www.ebay.com,www.shopping.com.
1) Can you suggest some articals or notes about having very good database design for the same ? As you can imagine there will be lots of category, sub category, inside category etc.
2) What should be the links of the differnet category ?
As some sites are having something like this http://www.epinions.com/btech ,http://www.epinions.com/bsrv-Office_Services ,http://www.epinions.com/bsrv-Office_Services-Business_Travel-All , http://www.epinions.com/bsrv-Office_Services-Online_Fax-All-eFax
Some of the compnies having url containing category and sub category.
some companies having just main category id.
I m sure they are doing considering search engines as well as
structure of the url.
Can some one can share their knowledge and experience to make my decision better?
|
|
|
|
|
I'd suggest a table relationship like the following:
Category
--------
CategoryID
CategoryName
ParentCategoryID
Product
-------
ProductID
ProductName
ProductLink
CategoryID
NOTE: If a product will appear in more than one category, delete the CategoryID in Product and add
ProductCategory
---------------
ProductID
CategoryID
Category had a zero/one-to-many relationship with itself.
Category has a one-to-many (or the second option a many-to-many) relationship with Product
Top level categories do not have a parent CategoryID
As for the links within the site - I'd just go for something like:
http://www.mysite.com/category.aspx?categoryID=354
From the code you can pick up the query string and use it to look the database up quickly.
IMO the directory approach is more difficult to set up and maintain.
Does this help?
--Colin Mackay--
EuroCPian Spring 2004 Get Together[^]
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
|
|
|
|
|
Thanks for your input..
It will certainly help to take decision.
Regards,
Coolvcguy
|
|
|
|
|
I am using this piece of script to open and close categories in a menu bar:
<script language='JavaScript'>
function switchVisibility(strObjName)
{
var opFolSrc = 'sysimageaction.asp?imagename=WebIcon_minus';
var clFolSrc = 'sysimageaction.asp?imagename=WebIcon_plus';
var theObject = document.all.item(strObjName);
if (theObject.style.display == 'none')
{
document.all.item('IMG' + strObjName).src = opFolSrc;
theObject.style.display = 'block';
}
else
{
document.all.item('IMG' + strObjName).src = clFolSrc;
theObject.style.display = 'none';
}
}
</script>
While it sucks like something that sucks a lot, it usually does what it is supposed to.
But at one of our customers the item list will never unfold (They are running IE6).
'Aha!', I thought, 'This must be a parameter in the internet options, piece of cake, just a matter of checking or unchecking an item'.
But I can't find any obvious settings that would disable JavaScripts, has anyone got a clue?
"After all it's just text at the end of the day. - Colin Davies
"For example, when a VB programmer comes to my house, they may say 'does your pool need cleaning, sir ?' " - Christian Graus
|
|
|
|
|
I think it's under SecuritySetting of the (Internet)Zone:
Scripting > ActiveScripting
(I use german IE, so don't blame me, if it's not the correct naming for the english menu entries)
|
|
|
|
|
Thank's a lot, that was the right setting.
"After all it's just text at the end of the day. - Colin Davies
"For example, when a VB programmer comes to my house, they may say 'does your pool need cleaning, sir ?' " - Christian Graus
|
|
|
|