connect to sql server 2005 problem - ASP / Active Server Pages

I want to retrieve data from sql server 2005 after clicking a button
so I do this code but it not work any help please

Expand|Select|Wrap|Line Numbers

 <html>

    <head>
 
    </head>

    <body>

        <%

            dim conn

            dim strconn ="Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MailSystem;Data Source=."

            Set cnt =Server.CreateObject("ADODB.Connection")

            cnt.ConnectionString= strconn

            cnt.Open

        %>

        <form method="Post">

            Enter Search Name <Input type="text" name="First"/> 

            <select name="Filter">

                <option>And</option>

                <option>Or</option>

            </select>

            <Input type="text" name="Second"/>

            <Input type="Submit" value="Search" name="Search"/>

        </form>

        <% if  Request.Form("Second")<>"" then

                sql="exec selectMesseges1'" & First & "','" & Filter & "','" & Second & "'"

            else

                sql="select *  from MessegesIDTable where subject like '" & First & "'+'%'"
 
            set rs=Server.CreateObject("ADODB.Recordset")

            rs.Open sql,cnt
 
        %>

    <table width="100%" cellspacing="0" cellpadding="2" border="1">

   <tr>

     <th>ID</th>

     <th>MailFrom</th>

     <th>ToID</th>

     <th>subject</th>

     <th>messege</th>

     <th>AttachedFile</th>

     <th>date</th>

     <th>read</th>

     <th>typeID</th>

   </tr>

   <%

    do until rs.EOF

           response.write("<tr>")

           response.write("<td>" & rs.fields("ID") & "</td>")

           response.write("<td>" & rs.fields("MailFrom") & "</td>")

           response.write("<td>" & rs.fields("ToID") & "</td>")

           response.write("<td>" & rs.fields("subject") & "</td>")

           response.write("<td>" & rs.fields("messege") & "</td>")

           response.write("<td>" & rs.fields("AttachedFile") & "</td>")

           response.write("<td>" & rs.fields("date") & "</td>")

           response.write("<td>" & rs.fields("read") & "</td>")

           response.write("<td>" & rs.fields("typeID") & "</td>")

           response.write("</tr>")

           rs.MoveNext

    loop

    rs.close

    conn.Close

    set rs=Nothing

    set conn=Nothing%>

    </table>

 <%  end if %>

    </body>

</html>

Dec 21 '08 #1

Subscribe Post Reply

1437

CroCrew

564

Expert 512MB

Look at line 13: <form method="Post">

The <form> needs an action like this:

<form name="xForm" action="Index.asp" method="post">

The action tells where to post the form too.

Hope this helps,
CroCrew~

Dec 23 '08 #2

Similar topics

Can't connect to SQL Server via ODBC

by: ~john | last post by:

I just installed PHP 5.1.4 with SQL Server 2005 on my laptop. PHP is running fine and so is SQL Server 2005. When I try to connect to SQL Server from my my PHP code I get this error. Warning:...

PHP

HELP! Why is SqlException being caught in this code if it can't connect to SQL Server?

by: Marcus | last post by:

I have a function that simply returns TRUE if it can connect to a particular Sql Server 2005 express, or FALSE if it cannot. I am getting some strange error codes returned when the computer that...

Visual Basic .NET

2005: cannot to connect from .NET

by: RAM | last post by:

Hello, Could you help me please to solve the prblem with connecting to SQL Server from .NET development environment? I have the following error: "An error has occured while establishing a...

Microsoft SQL Server

connect vb app to sql 2005 express

by: josh | last post by:

I'm pretty new to both sql 2005 and VB but please bear with me. I have installed SQL 2005 express on a Windows 2003 Standard server. I have also installed VB 2005 Express edition on the server. SQL...

Visual Basic .NET

Failing to connect to remote SQL Server 2000 from ASP.NET 2.0 application

by: tamayi | last post by:

I have a problem (like most others posting issues on this forum :) ) I have a remote server running Windows XP SP2, with both SQL Server 2005 Express with Advanced Features and SQL 2000...

ASP.NET

Cannot connect to database using Enterprise Manager

by: rubeel | last post by:

I cannot seem to connect to this Instance locally which was i able to in the past. I can connect to the instance from out side. The instance is running and the DBs in the instance are available and...

Microsoft SQL Server

Error trying to connect to local database - What is going on?

by: Alan Silver | last post by:

Hello, Server configuration: Windows 2003 Server SP2 SQL Server 2000 SP4 ..NET v2.0.50727 just built up a new server using the same configuration as my current one. I even used the same CDs...

ASP.NET

Db connect problem

by: Peter Lux | last post by:

I'm fairly new to c#, but not new to programming. I'm tasked with rewriting our Gupta/Sqlwindows apps (5 years worth of development) in dot Net. The main reason is that virtually no one knows the...

C# / C Sharp

Re-Connect with Remote SQL Servr 2005 Database

by: BD | last post by:

I am developing C# win form app to work with remote database on SQL Server 2005. Problem scenario is as follows: 1. a form is open that has downloaded dataset to local cache 2. computer is...

C# / C Sharp

Connect To Local SQL Server DB From Remote Server

by: RN1 | last post by:

Is it possible to connect to my local SQL Server 2005 database from a remote web server? If yes, what ConnectionString do I use? Thanks, Ron

ASP.NET

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server