Its throwing some kind of javascript error. You can check error details by clicking the warning icon in the status bar on bottom left side of the page. Thanks

Hi Friends Please check this link in IE8: http://www.freej.ae/freejaetest/ar/FreejEpisodes.aspx. If you select first link below page title from right in the above link, You will see a jcarousel in the bottom which is not displaying correctly...But when I see it on my local machine its showing up correctly but online its not showing up correctly. I am puzzled as what might have went wrong as both the local and online versions are same with same codebase and same data. Please help me in resolving th issue. Site is developed in Asp.net. Thanks

Hi friends Has anyone done a db for a multi-level compensation structure? I'm talking about a company that is MLM or a multi-level marketing network. Where distributors sign up under other distributors and the "downline" can go down many levels(but limited levels!). I need a sample MLM structure.Could anybody help me please. Thank You http://tutorialcode.blogspot.com/

Hi I think I have not explained the problem clearly. So in simple terms, I want to say that I have created a usercontrol and using it in a page at the top and bottom. I want to apply two different themes to the top and the bottom user control. Thanks

Hi friends I have created a user control with name menuUserControl with menu control in it. I have created a user defined property for the user control(menuUserControl) as groupid and when ever I pass groupid to the user control(menuUserControl) in a page, it should use a theme based on the groupid I pass to it. For example if I use two user controls(menuUserControl) one at the top and other at the bottom of the the page with two different groupids like if I pass groupid=1 for top user controls(menuUserControl), it should use theme1 and groupid=2 to the bottom user controls(menuUserControl), it should use theme2. So my problem is that I am unable to apply theme to the user control. I have done some google search but unable to create a theme for a user control. I am only able to apply themes to the server controls. As I am using two user controls i.e menuUserControl as said above, both are displaying same theme. I want to apply two different themes to two user controls(menuUserControl). If any one have any solution or any other alternative, kindly help me please, Its very urgent for me. If you did not understand or you have any doubt, please reply back, I will try to analyze the problem. Hope to get a positive response. Thanks Wajid

Thanks a lot. Its working now.

Hi All I am getting problem in putting text at the cursor location in freetext box which is place in a Place holder and . My code is as follows:

             First Name
    Last Name
    Email      

the statement

"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);"

is working fine on Internet Explorer but its not working on firefox Please help me Thanks wajans

modified on Friday, November 7, 2008 7:52 AM

Thanks for your reply I found the solution, want to share with the needful.

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

ALTER PROCEDURE [DBO].[AddEditUserMsgDetails]
(
@iJobID [NUMERIC]=NULL,
@iUserID [NUMERIC]=NULL,
@vFromName [VARCHAR](50)=NULL,
@vFromAddress [VARCHAR](50)=NULL,
@vSubject [VARCHAR](50)=NULL,
@iListID [NUMERIC]=NULL,
@vActualText [TEXT]=NULL
)
AS
BEGIN
/* Written By: Wajid Ahmed Ansari
Date: 05-11-2008
Logic Comments: INSERTING OR UPDATING INTO THE TABLE ezlMailJobs
EXEC AddEditUserMsgDetails null,505,'waa','waa@v-empower.com','Test',816,'Hi <!FN>
please ignore
'
EXEC AddEditUserMsgDetails NULL,505,'Khadri','khadr.syed@v-empower.com','Testing Procedure',NULL,NULL
EXEC AddEditUserMsgDetails 4,505,'Khadri','khadr.syed@v-empower.com','Testing Procedure',816,NULL
SELECT * FROM ezlMailJobs
sp_help ezlMailJobs
*/
SET NOCOUNT ON
DECLARE @Return [NUMERIC]
SET @Return=NULL
BEGIN TRAN
IF @iJobId IS NULL OR @iJobId=0
BEGIN
INSERT INTO table1 (iUserID,vFromName,vFromAddress,vSubject,iListID,vActualText)
VALUES (@iUserID,@vFromName,@vFromAddress,@vSubject,@iListID,@vActualText)
SET @Return= SCOPE_IDENTITY()
SELECT @Return AS iJobId
END
IF @iJobId IS NOT NULL
BEGIN
UPDATE table1 SET iUserID=@iUserID,vFromName=@vFromName,vFromAddress=@vFromAddress,
vSubject=@vSubject,iListID=@iListID,vActualText=@vActualText
WHERE iJobId=@iJobId
SELECT 0
END
IF @@ERROR=0
BEGIN
COMMIT TRAN
END
ELSE
BEGIN
ROLLBACK TRAN
SELECT -1
END
SET NOCOUNT OFF
END

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

Hi All I am getting problem in putting text at the cursor location in freetext box which is place in a Place holder and . My code is as follows:

             First Name
    Last Name
    Email      

the statement

"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);"

is working fine but when i change it to get value instead of text as

"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].value);"

its not showing any thing in the freetext box. Please help me Thanks wajans

Hi All I am getting problem in putting text at the cursor location in freetext box which is place in a Place holder and . My code is as follows:

             First Name
    Last Name
    Email      

the statement

"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);"

is working fine but when i change it to get value instead of text as

"FTB_API['ctl00_ContentPlaceHolder1_ftbMailText'].InsertHtml
(ddlPlaceHolders.options[ddlPlaceHolders.selectedIndex].text);"

its not showing any thing in the freetext box. Please help me Thanks wajans

Hi All I am writting an stored procedure to get the recently inserted records primary key as follows:

ALTER PROCEDURE [DBO].[AddEditUserMsgDetails]
(
@iJobID [INT]=NULL,
@iUserID [INT]=NULL,
@vFromName [VARCHAR](50)=NULL,
@vFromAddress [VARCHAR](50)=NULL,
@vSubject [VARCHAR](50)=NULL,
@iListID [INT]=NULL,
@vActualText [VARCHAR](100)=NULL
)
AS
BEGIN
/*
Logic Comments: INSERTING OR UPDATING INTO THE TABLE ezlMailJobs
EXEC AddEditUserMsgDetails null,505,'waa','waa@v-empower.com','Test',816,
'Hi <!FN>
please ignore
'

*/

IF @iJobId IS NULL OR @iJobId=0
BEGIN
INSERT INTO ezlMailJobs (iUserID,vFromName,vFromAddress,vSubject,iListID,vActualText)
VALUES (@iUserID,@vFromName,@vFromAddress,@vSubject,@iListID,@vActualText)
set @iJobID= @@Identity
select @iJobID
END
IF @iJobId IS NOT NULL
BEGIN
UPDATE ezlMailJobs SET iUserID=@iUserID,vFromName=@vFromName,vFromAddress=@vFromAddress,
vSubject=@vSubject,iListID=@iListID,vActualText=@vActualText
WHERE iJobId=@iJobId
END
IF @@ERROR=0
BEGIN
COMMIT TRAN
SELECT 1
END
ELSE
BEGIN
ROLLBACK TRAN
SELECT -1
END

As in the above stored procedure when ijobid is null or zero, It should execute insert statement and return recently inserted records ijobid else it should execute update statement. But as now it is executing insert statement and returning some garbage value. one more thing I have declared ijobid as identity. I am unable to figure out the problem. Please help me. Thanks WAA

Hi All I want to have a dynamically generated menu from a dynamically generated web.sitemap file which gets populated from the database. Is it possible. Your help is greatly appreciated. Thanks Ansari

Hi I have tried to analyse my requirement below.

mainmenu--TableName
iMenuId vRefTable----ColoumnNames
58 news ---------Records

TableField
iMenuId bIsPrimary iTableFieldId vFieldsName
58 1 11 iNewsId

news

iNewsId vTitle vUR
1 news1 http://www.gmail.com

I am storing tablenames in MainMenu in vRefTable coloumn and coloumn names in vFieldsName of TableFields table. I want to extract tablename from MainMenu whose iMenuId=58 and coloumn name from TableField table whose iMenuId=58 and bIsPrimary=1 and iTableFieldId=11 i.e iNewsId. After this I will be having both table name and coloumn name, using this I want to extract data based on the table name & coloumn name which I am having. Thanks again Ansari

Hi I want to execute below query in ms-sql server 2000 but its giving errors. Can anybody help please.

select * from ( select vRefTable from mainmenu where iMenuId=58 )
where (select vFieldsName from TableField where iMenuId=58
and bIsPrimary=1 and iTableFieldId=11) = 1

Its showing below errors. your help is greatly appreciated.

Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'where'.
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near '='.

Thanks Ansari

Thanks a lot Guffa for your quick reply. It works great.

modified on Friday, September 19, 2008 5:54 AM

Hi Guffa My requirement changed, I am sure you can help me. I have a string for example str="something [!str1] and something [!str2].." so I want to store the substring from start up till "[" and then from "[" to "]" and so on. so how can we achieve it. Thanks Ansari

Hi After doing r&d on regular expressions I got this answer. If we want to extract a word from a string like "[something]" We could use the Match method in the regular expression. Like this: string s = "

[!vDescription][!vDate]

[!vTitle]

"; Regex rx = new Regex(@"\[.*?\]"); Match mc = rx.Match(s); while(mc.Success) { Response.Write(mc.Value.ToString()); mc = mc.NextMatch(); } Thanks

Hi John I have a string which do not have spaces. Its something like this "

[!vDescription][!vDate]

[!vTitle]

", Sorry to not mention it in my earlier post. Hope you will reply back with the solution. Thanks for your reply. Thanks Ansari

Hi Guffa Thanks for your reply. I am getting "Invalid expression term '>'" error. Please help resolve this issue. Thanks Ansari

Hi I want to extract sustrings from a string and want to store in an array. The string is dynamic it will change but the criteria to extract substring is same. say for example a string str="something is [!better] than [!nothing]" so i need to extract [!better] and [!nothing] from the string and store it in a string array, the string is dynamic it changes but i need to extract data between [ and ] including both the square brackets. If anybody can send any sample code, I will be very thankfull. Thanks Ansari