|
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.ExecuteADO 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
|
|
|
|
|
|
r u sending the right http headers b4 u send the data?
"there is no spoon"
biz stuff about me
|
|
|
|
|
Hi Lauren,
I am sending something like this
<br />
<% Response.Buffer = TRUE <br />
Response.ContentType = "application/ms-excel" %><br />
<html><br />
<body><br />
<%<br />
Dim vntStream<br />
Set oMyObject = Server.CreateObject("MyObject.BinRead")<br />
vntStream = oMyObject.readBinFile("c:\temp\tempxls.xls")<br />
Response.BinaryWrite(vntStream)<br />
Set oMyObject = Nothing<br />
Response.End<br />
%><br />
</body><br />
</html><br />
Thanks in adavance,
AL
|
|
|
|
|
There must be no text outside the asp-tags (<% %>).
Especially remove the body-Tags.
|
|
|
|
|
I am primarily concerned with results on google only and have a fair idea of how SEO used to work META tags, keywords, TITLE, etc...
While reading an optimization sheet for google it suggests there isn't much you can do to optimize a search with google becuz it relies heavly on linking with other sites.
So my question is this...
I have a few products I would like to sell on my site and have considered developing a seperate web site dedicated just to that product
www.product1.com
www.product2.com
etc...
Each of these products would have a link somewhere pointing back to my web site and visa-versa...
Supposedly this is how to drive your ranking up on google....
So, does a sub-domain work equally as well?
www.product1.mywebsite.com
www.product2.mywebsite.com
I read something about this not working becuz the sub-domains don't have static IP's?
If I have made any sense and you know what your talking about, please give me yer opinions...
Thanks
Cheers 
The word of the day is legs, let's go back to my house and spread the word 
|
|
|
|
|
What you're describing is commonly known as a link-farm, and Google has been cracking down on those as well.
Rather than spend the time and money on setting up multiple web sites, try buying some ad space on relevant sites, or even on Google. I'd bet that you get better response and visitors clicking on an ad are probably looking to buy some product (hopefully yours naturally).
|
|
|
|
|
I have to consume a set of Java APIs on the web server application from my ASP.net web service. Is there a way to do it?
|
|
|
|
|
A number of examples of web services include a .asmx file that typically has a single line
<%@ WebService Language="c#" Codebehind="WebService1.cs" Class="MyService.WebService1" %>
This is also documented in the .NET SDK for creating a web service. In the case of the examples and the SDK they indicate that if you open the file with a browser, the browser should display information about the web service. I am very unsuccessfully having IE6.0 do that for me. All the browser will do is prompt me for a program to open the file with and when I intruct it to use IE, it simply displays the text of the file.  I'm likely interpretating something very wrong here, but at a complete loss of what. Any kind pointers would be appreciated. Thanks.
Chris Meech
We're more like a hobbiest in a Home Depot drooling at all the shiny power tools, rather than a craftsman that makes the chair to an exacting level of comfort by measuring the customer's butt. Marc Clifton
VB is like a toolbox, in the hands of a craftsman, you can end up with some amazing stuff, but without the skills to use it right you end up with Homer Simpson's attempt at building a barbeque or his attempt at a Spice rack. Michael P. Butler
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
