I am not sure about it............. .I am passing the parameter with SP for the first time........... ........But if we give SELECT @Campaign_Name = 'hello' before the insert stmt, when we call the SP that value will be updated in the database....... ..
But I dont know how to pass values from ASP form..........
CREATE PROCEDURE [dbo].[SP_SMS]
AS
BEGIN
SET NOCOUNT ON;
Declare...
neenaprasad
Last Activity: Sep 7 '08, 05:49 AM
Joined: Jan 28 '08
Location: Kochi
-
Can you tell me where to use the "#" button?...Leave a comment:
-
Passing parameters through form with stored procs in ASP
I am trying to pass parameters through form ............... .....
Getting the following error.......... .
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure SP_SMS has no parameters and arguments were supplied.
---------------------- Here is my code ---------------------...Last edited by DrBunchman; Aug 19 '08, 06:43 AM. Reason: Added [Code] Tags - Please use the '#' buttonLeave a comment:
-
Passing parameters through form with stored procs in ASP
I am trying to pass parameters through form ............... .....
Getting the following error.......... .
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
-------------------------------------------------------------------------------------------------------------
The error is in line.......... CmdUpdate.Comma ndType...Last edited by DrBunchman; Aug 19 '08, 06:44 AM. Reason: Added [Code] Tags - Please use the '#' button -
Round to 2 decimal
I wrote an Sql as :-
SELECT CAST(ROUND(SUM( CASE Question11 WHEN 1 THEN 1 ELSE 0 END), 0) AS numeric) * 100 /
(SELECT COUNT(*)
FROM CustomerFeedbac k
WHERE (Question11 <> 0)) AS Expr1
FROM CustomerFeedbac k
The output is 66.6666........ ............... .
I want... -
record count shows value -1
Set x_FromDate = request.QUERYST RING("x_FromDat e")
If isdate(x_fromDa te) then
x_FromDate = CDate(x_FromDat e) 'Request.Form(" x_FromDate")
end if
Set x_ToDate = request.QUERYST RING("x_ToDate" )
If isdate(x_ToDate ) then
x_ToDate = CDate(x_ToDate) 'Request.Form(" x_FromDate")
End If
...Leave a comment:
-
record count shows value -1
I have to take values from two tables with single sql statement.
SQl = SELECT MemAccounts.Mem berID,COUNT(Mem Accounts.Member ID) AS Total, Membership.Firs t_Name, Membership.Last _Name FROM MemAccounts, Membership WHERE MemAccounts.Int roduceeID <> 0 AND Membership.IsAg ent = 1 AND MemAccounts.Mem berID = Membership.Memb erID AND MemAccounts.Tra nsDate BETWEEN '" &x_FromDate& "' AND '" &x_ToDate&... -
hi,
From a table i displayed the Agents memberid, firstname,lastn ame & total introduced(no of members each Agent introduced)
the code is as follows..
StrSql = "SELECT MemberID,First_ Name,Last_Name, Introducedby FROM Membership where IsAgent = 1"
Set rsAgents = Server.CreateOb ject("ADODB.Rec ordset")
rsAgents.Open StrSql, conn, 1, 2
rsAgents.Movefi rst
...Leave a comment:
-
temporary table
i created a temporary table like this
SqlStr = "CREATE TABLE #t_temp(MemberI D int, First_Name varchar, Last_Name varchar, Introducedby int)"
inserted values id,firstname,la stname and x_intro(is the count)
SqlStr = "INSERT MemberID, First_Name,Last _Name from Membership AND x_intro INTO #t_temp where Introducedby = " &x_introAgen t
i have to get the output order... -
temporory table showing error
I created a temporary table like this. It showed an error like this
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/neena/BestAgentsList. asp, line 334, column 16
SqlStr = CREATE TABLE #t_temp
Line 334 is SqlStr = CREATE TABLE #t_temp
My temporary table is
SqlStr = CREATE TABLE #t_temp
(
MemberID int,
First_Name Varchar(50),... -
where and how to use temparary tables?
I have many rows in my table. I have to select id, first_name, last_name, introduced_by into a temporary table.all the members (names) in the table are not agents. In my table there another field named is_agent. If is_agent field is true that means he is an agent. In the introduced_by field agents_id occur more than once.i have to count the no of times agents_id occurs and display it in the temporary table. Can you help me? -
neenaprasad started a topic counting the no of times a value occured and sorting the fields in a tablein ASP Classiccounting the no of times a value occured and sorting the fields in a table
In the table the fields are id, first_name, last_name, introduced_by (which is integer value i.e., 1,2,3,4,5...). This number occurs more than once in the table. I have to count the number of times each number occurs(that means a single value for eg: 2) and sort it according to the count and display the output in ascending order..Can u help me? -
how to sort fields in table
i have a table having fields id,name, address,introdu ced-by (which is a no).i have to sort the fields in ascending order of introduced-by.how should i do this
No activity results to display
Leave a comment: