atinobrian

you are trying to insert two values (canAdd and canEdit) in a single row, but treeview will loop twice for two checkboxes , plus your insert statement is inside the loop hence two entries By the way what does getcheck function do here ?

Please check if you are able to connect using sql server management studio on the same name "naheed-pc1\mycloudflash" if not, then use the same name as shown in the sql server management studio

you can check the previous url using HTTP_Referer, You can get the current domain name by using Request.ServerVariables("server_name")

you are trying to pass sno as a parameter, Is sno an auto generated Identity key column ? if so then you cannot pass value to sno while inserting as the values will be autogenerated . In any case kindly post more details

@@Fetch_Status Returns the status of the last cursor FETCH statement issued against any cursor currently opened by the connection. Since you have not opened a Cursor yet , its giving -1 as a value. check this msdn article for more details http://msdn.microsoft.com/en-us/library/ms187308.aspx

well hereis a more simpler way Delete t1 from <tbl_> t1,<tbl_> t2 where t1.ID= t2.ID and t1.[Date] <t2.[Date]

[code] update t1 set t1.status = 'X' from t2 inner join t1 on t2.txn_id = t1.txn_id where t2.date < sysdate. [/code] :)

what part are you not able to understand we can go part by part on this :),comments are making it self explanatory, anyways kindly start with what part of this code are u finding hard to understand

[code] select * from Reports where UserId = @id and datepart(mm,ReportDate) = @month and datepart(year,reportdate)= @year [/code]

.aspx are you saying you want to convert a web form to a .jad ( which is like a windows application) ? I think you need to use windows project for making installable applications on mobile

[QUOTE=wildpetals;781501]Ok, so now I got past that error and now, there's an error with the joins? this is definitely not something I'm that good with yet. I am receiving the following error: syntax error (mising operator) in query expression ' dbo.CLIENT ON dbo.PHONE.CLIENT_ID = dbo.CLIENT.CLIENT_ID RIGHT OUTER JOIN dbo.CLIENT_TRANS ON …

Can you post your javascript code ? It would make things easier :)

[QUOTE=sonakrish;788769]hi all.... I'm trying mailing concept. After entering FROM address, TO address ,subject and body of the message and while clicking the send button am getting [COLOR="Green"] Mailbox unavailable. The server response was: 5.7.1 Unable to relay for "[email protected]" [/COLOR] what wrong i would have made? Plz guide me[/QUOTE] Are …

assuming that the col1 is having unique constraint in both the tables [code] insert into Table A(col1,col2,col3) select TableB.col1,TableB.col2,TableB.col3 from Table B left outer Join Table A on Table B.col1 = Table A.col1 where TableA.col1 is null [/code]

I think this should help [url]http://forums.asp.net/p/1001732/1321474.aspx[/url] Please mark the thread as answered if it solves our problem