|
Member 4429208 wrote: "UPDATE news SET subj='aasda22', text='sdasd', WHERE id='4'"
Remove the comma before WHERE
Concatenate a statement like this
"UPDATE news SET subj='aasda22', text='sdasd' WHERE id='4'"
Hope this helps
foreach(Minute m in MyLife)
myExperience++;
|
|
|
|
|
Thank you Mohammed, i've tried that too and it failed with a syntax error in update statement.
any other ideas?
thanks,
Basil
|
|
|
|
|
WHERE id='4' is your ID column type is a VAR/NVARcher type ?
MyDevBank.com
|
|
|
|
|
the ID column is an Auto-number..
?
|
|
|
|
|
you got WHERE ID='4' try WHERE ID=4
|
|
|
|
|
|
one of the fields name is wrong, Cap letter or something like that
MyDevBank.com
|
|
|
|
|
This should do the trick;
UPDATE news
SET subj='aasda22'
,[text]='sdasd'
WHERE id='4' "Text" should be avoided as a column-name; it's a reserved word.
I are Troll
|
|
|
|
|
mydevbank thank you
Eddy Vluggen!! thanks a lot brother, it worked. i never though of that lol!! TEXT is a reserved word. wth !! ive been dealing with this thing for a week and never though of changing columns names
thanks anyway for all
|
|
|
|
|
You're welcome
|
|
|
|
|
|
Deserve MVP
foreach(Minute m in MyLife)
myExperience++;
|
|
|
|
|
Thanks
|
|
|
|
|
Hi all
info:
1) master page(mstr.master) has treeview control
2) aspx pages(detail.aspx and list.aspx) have mstr.master as their master
3) detail.aspx uses $.ajax.... to retrieve the content from detailcontent.aspx(which has no master)
Problem scenario :
(a) detail.aspx has finished loading, with the content from detailcontent.aspx
(b) I click a node in treeview which should load list.aspx(with mstr.master) but then the problem occurs.
(c) the problem is that the postback from the treeview is sent to detailcontent.aspx.
Any suggestions?
|
|
|
|
|
sigurdur einarsson wrote: detail.aspx uses $.ajax....
What do you mean by this?
sigurdur einarsson wrote: I click a node in treeview
Where is that treeview, in which page?
foreach(Minute m in MyLife)
myExperience++;
|
|
|
|
|
- $.ajax...
on document ready in detail.aspx I call jquery ajax function(http://api.jquery.com/jQuery.ajax) which retrieves content from detailcontent.aspx
- treeview
master page(mstr.master) has the treeview control, thus always visible
|
|
|
|
|
Could you please, send the event handler of node click
foreach(Minute m in MyLife)
myExperience++;
|
|
|
|
|
Hi Mohammed Gouda
(have been working shifts last 3 days, got your email just now, thanks for the reaction)
- rendered node in html :
- these two functions(E_TreeNodePopulate,E_TreeNodeExpanded) handle it when the above node is clicked :
public void E_TreeNodePopulate(Object source, TreeNodeEventArgs e)
{
if (Session["SelectedNodeChanged"] == null)
{
int currentuserid=-1;
if (Session["userObj"] == null)
currentuserid = 0;
else
currentuserid = Convert.ToInt32(((UserObject)Session["userObj"]).Id);
foreach(TreeNode tn in e.Node.ChildNodes) //in the beginning the root should be e.Node
{
int treenodeuserid = TreeNodeHelper.getIdFromTreeNodeValue(tn.Value);
if (treenodeuserid == currentuserid)
{
Session["SelectedNodeChanged"] = tn;
Session["DisplayContactUserId"] = null;
}
}
}
populateSelectedNode(e.Node);
}
protected void E_TreeNodeExpanded(object sender, TreeNodeEventArgs e)
{
populateCollectionPage(e.Node);
}
cheers, Siggi
|
|
|
|
|
I did not understand the reason behind calling these 2 events
If I were you, I would handle one event instead.
The best event for this scenario is the SelectedNodeChangedof the treeView, and it should be something like this
protected void TreeView1_SelectedNodeChanged(object sender, EventArgs e)
{
Response.Redirect("list.aspx");
}
foreach(Minute m in MyLife)
myExperience++;
|
|
|
|
|
Hi ,
l am using jquery and jquery.corner pluging to create div rounded with border.
i get it, but my problem is that
i want to use drop shadow on bottom and right side of div . i am searching it last couple of days
but no getting it. i also have used liquid canvas but did not find correct solutions
Please suggest How to do it?
|
|
|
|
|
with jquery UI you can do it
i think its css class ".ui-widget-shadow" but set the margin(for the shadow) as you like around the div
MyDevBank.com
|
|
|
|
|
HI,
I am new for jquery and using last couple of days.I have no idea that how to use jquery UI and css class
.ui-widget-shadow.
please let me know how to use it.
|
|
|
|
|
to make it short...
download this
open a index.html file in your browser its a demo
in the shadow case -> look at the dialog demo -> look at the html , class="ui-widget-shadow ui-corner-all"
now add the folders to your site/web app
then set this html in a page for a test
link the 2 js file and css to that page
<div style="width:100px;"><div class="ui-corner-all ui-widget-shadow" ><div class="ui-dialog-content ui-widget-content">test 123</div></div></div>
you should get a small shadow around a div with a test 123 text in it
now you need to set the margin of the shadow so it will have an angel relating the text div
it take some time to get in to it but its a great tool for web development
reply back for results
MyDevBank.com
|
|
|
|
|
|
Hi
Anybody know how to get the Stock ticker from Indian Share market to our asp.net webbased application.??
Wanted to develop a mock application using that.
Thank you
With regards
Sobeja
|
|
|
|