what is that mydealerInfo.of fers meant for . . Is it an array from third party . .
Regards
Nedu...
nedu
Last Activity: Nov 29 '10, 09:37 PM
Joined: Nov 2 '06
Location:
-
can u bit more clear abt the issue . . I doesn't understand what the actual problem is . .
Regards
Nedu...Leave a comment:
-
Hey there is a problem in the date format . . Try the below code . .
<%
Dim varNow, expTime 'create variable that will store date and time
varNow=Now 'the Now function returns the date & time - assign it to the variable
expTime="05/11/2010 13:00:00"
Response.Write( CDate(expTime)) & "<br>"
Response.Write( CDate(varNow)) & "<br>"...Leave a comment:
-
Hi,
You shall use the below code . .
if exists (select * from dbo.sysobjects where id = object_id(N'tem pdb..#temp1') and OBJECTPROPERTY( id, N'IsUserTable') = 1)
Begin
drop table [#temp1]
print 'dropped'
End
Else
Begin
print 'No Such tables'
End
Regards,
Nedu. MLeave a comment:
-
Hi,
I m planning to use Classic ASP. Could u please let me know some reference URL's.
Thanx,
Nedu. M...Leave a comment:
-
Hi,
Please check this and let me know is t working r not . .
select startdate from ClientRegister where startdate between
startdate and ( DateAdd(day,13, startdate) from ClientRegister
Regards,
Nedu. MLeave a comment:
-
Creating Treeview using ASP and Sql server
Hi,
Will anyone plz help me in designing the tree view from the data from database table. Is there any reference URL or example source available. Plz let me know some reference for this.
Thanx in Advance . .
Regards,
Nedu. M -
Hi,
Please post u r questions clearly . . .
Regards,
Nedu. MLeave a comment:
-
Hi,
Is this code wrking?????? R u need any othr help???????Leave a comment:
-
Hi,
Explain clearly what u want, so that we shall help u??????
Regards,
Nedu. MLeave a comment:
-
Hi,
Try this query. It may work as per u r requirement . .
[code=sql]
select m.prod_id, isnull(sum(R.RE CEIVED_QTY),0) receipt, isnull(sum(D.DE SPATCH_QTY),0) despatch
from product_master m
left outer join RECEIPT_TR r on m.prod_id=r.pro d_id
left outer join DESPATCH_TR d on m.prod_id=d.pro d_id
group by m.prod_id[/code]
Regards,
Nedu. MLeave a comment:
-
Hi,
I think u r updating the DB. Try using the SP for updation.
Regards,
Nedu. MLeave a comment:
-
Hi ,
U can use the following code . .
ClickMe.asp
<HTML>
<BODY>
<a href="download. asp?fname=1.xls ">Click hereto Download</a>
</BODY>
</HTML>
Download.ASP
on error resume next
Response.Conten tType = "applicatio n/x-unknown" ' arbitrary
fname = Request.QuerySt ring("fname")...Leave a comment:
-
Hi,
Try this
http://support.microso ft.com/kb/268364
Regards,
Nedu. MLeave a comment:
-
Hi,
You shall set the Scripttimeout using following syntax
Server.ScriptTi meout[=NumSeconds]
Try This . .
Regards,
Nedu. MLeave a comment:
-
I think there is no need of newPassword field, only one password field is enough u shall replace the new pwd in that itselfLeave a comment:
-
Hi Frnd,
I thnk the password field name of u r table is "PassW" but in the update statement u r updating the different filed "NewPassW". Please check that and let us know . . .
Regards,
Nedu . MLeave a comment:
-
CREATE function num_test(@varco l varchar(10)) RETURNS varchar(10)
AS
BEgin
declare @i int
DECLARE @MyOutput varchar(10)
set @i = 1
SET @MyOutput = ''
while (@i<=len(@varco l))
begin
If ISnumeric(subst ring(@varcol,@i ,1)) = 1
begin
SET @MyOutput = @MyOutput + substring(@varc ol,@i,1)
End
set @i=@i+1
end
RETURN @MyOutput
END
...Leave a comment:
-
select numeric value from varchar data type + sql server
Hi all,
Assume the col value has following.
col1
----------------
1asd
asd2
as3asf
I need the output as
col1
----------
1
2
3
We need to fetch only the integer value from the varchar datatype. Position of the int value is not static it may vary for the data. Anyone plz help me is there any function to do it?????
... -
-- Current 1 Month
Select A.acountid,sum( A.net) from test3 A where
convert(varchar ,col2,111)
between Convert(varchar ,DATEADD(mm, DATEDIFF(mm,0,g etdate()), 0) ,111)
and convert(varchar ,dateadd(ms,-3,DATEADD(mm, DATEDIFF(m,0,ge tdate() )+1, 0)),111)
and A.acountid in
(
Select top 10 acountid from test3
where convert(varchar ,getdate(),111) = convert(varchar ,col2,111) --convert(varchar ,'11/22/2007',111)...Leave a comment:
No activity results to display
Leave a comment: