Re: filtering results by input box?

#1

On Tue, 15 Jan 2008 05:36:34 -0800 (PST), kevin (AT) nu-urbanmusic (DOT) co.uk
wrote:

Better ask that question in a Dreamweaver newsgroup.
-Tom.

Quote:

Hi, i'm new to mssql, i've come from php/mysql.. anyway, i'm using SQL
Server 2005.. I've connected to the DB using dreamweaver and
sucessfully displayed a recordset on a page as follows:
clip

#2

On Jan 15, 2:12*pm, Tom van Stiphout <no.spam.tom7... (AT) cox (DOT) net> wrote:

Quote:

On Tue, 15 Jan 2008 05:36:34 -0800 (PST), ke... (AT) nu-urbanmusic (DOT) co.uk
wrote:

Better ask that question in a Dreamweaver newsgroup.
-Tom.

Hi, i'm new to mssql, i've come from php/mysql.. anyway, i'm using SQL
Server 2005.. I've connected to the DB using dreamweaver and
sucessfully displayed a recordset on a page as follows:

clip

does it make a difference what package i use to create the page, what
if i'd have used notepad?!
isn't the code the same?
sorry for my ignorance!

#3

can i do it in microsoft visual studio instead somehow?

#4

(kevin (AT) nu-urbanmusic (DOT) co.uk) writes:

Quote:

On Jan 15, 2:12*pm, Tom van Stiphout <no.spam.tom7... (AT) cox (DOT) net> wrote:
On Tue, 15 Jan 2008 05:36:34 -0800 (PST), ke... (AT) nu-urbanmusic (DOT) co.uk
wrote:

Better ask that question in a Dreamweaver newsgroup.
-Tom.

Hi, i'm new to mssql, i've come from php/mysql.. anyway, i'm using SQL
Server 2005.. I've connected to the DB using dreamweaver and
sucessfully displayed a recordset on a page as follows:

clip

does it make a difference what package i use to create the page, what
if i'd have used notepad?!
isn't the code the same?
sorry for my ignorance!

The question was about getting a value from an input box. And, no,
that is not an SQL Server problem. You would have exactly the problem
if you connected to Oracle, DB2 or whatever. SQL Server cannot access
your form or you input.

If what you posted is Dreamweaver, you need to ask in a Dreamweaver
newsgroup. Mind you, I don't even know what Dreamweaver is. And we are
not supposed to this here either.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

#5

On Tue, 15 Jan 2008 06:51:49 -0800 (PST), kevin (AT) nu-urbanmusic (DOT) co.uk
wrote:

Yes it does make a huge difference. Each tool connects to the database
differently, and binds controls to fields in the database differently.
In a Dreamweaver group they can tell you how to do that with that
tool.

-Tom.

Quote:

On Jan 15, 2:12*pm, Tom van Stiphout <no.spam.tom7... (AT) cox (DOT) net> wrote:
On Tue, 15 Jan 2008 05:36:34 -0800 (PST), ke... (AT) nu-urbanmusic (DOT) co.uk
wrote:

Better ask that question in a Dreamweaver newsgroup.
-Tom.

Hi, i'm new to mssql, i've come from php/mysql.. anyway, i'm using SQL
Server 2005.. I've connected to the DB using dreamweaver and
sucessfully displayed a recordset on a page as follows:

clip

does it make a difference what package i use to create the page, what
if i'd have used notepad?!
isn't the code the same?
sorry for my ignorance!

#6

cheers tom, thanks for your help

it's good to here why so i can start to understand.

kev

#7

On Jan 15, 5:36*am, ke... (AT) nu-urbanmusic (DOT) co.uk wrote:

Quote:

Hi, i'm new to mssql, i've come from php/mysql.. anyway, i'm using SQL
Server 2005.. I've connected to the DB using dreamweaver and
sucessfully displayed a recordset on a page as follows:

%@ Page Language="VB" ContentType="text/html"
....

Quote:

now, my question is, how can i create a simple form with one input box
so that i can change the current hardcoded filter from:

SL.CustomerAccountNumber = 'CHE001'

to whatever is entered into the input box.

Ok, you are in a wrong newsgroup.
HOWEVER... just go to the Dataset dialog box and select the field used
as to enter the filter...

P

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: filtering results by input box?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: filtering results by input box? - 01-15-2008 , 08:12 AM

Re: filtering results by input box? - 01-15-2008 , 08:51 AM

Re: filtering results by input box? - 01-15-2008 , 09:01 AM

Re: filtering results by input box? - 01-15-2008 , 05:11 PM

Re: filtering results by input box? - 01-15-2008 , 09:56 PM

Re: filtering results by input box? - 01-16-2008 , 06:18 AM

Re: filtering results by input box? - 01-16-2008 , 12:03 PM