|
Hello guys,
I want to update my Access database. I can update all fields of the table except password field.
If i omit password field from the QuerryString, remaining fields are successfully updating. E.g.
QuerryString = "update Users set name=@name,emailid=@emailid,dob=@dob,address1=@address1,address2=@address2,city=@city,state=@state,pincode=@pincode,country=@country,accounttype=@accounttype,boss=@boss where username='ABC'";
This is successful.
But when i add password field to it, its showing syntax error in update stmt. e.g.
QuerryString="update Users set password=@password,name=@name,emailid=@emailid,dob=@dob,address1=@address1,address2=@address2,city=@city,state=@state,pincode=@pincode,country=@country,accounttype=@accounttype,boss=@boss where username='ABC'";
This is showing error:"Syntax Error in Update Stmt."
Can anyone help me?
Thanks,
Nagendra.
|
|
|
|
|
Do you add the password parameter ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Yes, Ofcourse i added that.
|
|
|
|
|
well, if you don't post the code...
what if you run the same code within your database itself ? Obviously inserting values, does it work ?
If password is a reserved word ( I don't think it is ), putting it in [] will work, for SQL Server at least.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi there,
I don't really know whether password is a reserve word or not but i renamed it to pwd and it worked.
Thnx,
Nagendra.
|
|
|
|
|
nagendrathecoder wrote: password=@password
password might be a reserved word. Try renaming this column
|
|
|
|
|
Hey Navneeth,
Thnx man, ur suggestion worked.
I changed password to pwd and it updates successfully.
Thnx again.
Nagendra.
|
|
|
|
|
or he can put it in [] like [password]
|
|
|
|
|
hi
i have some categories but i like to only save their ID in my database
i'd like to know where should i save their names and IDs? in xml file? dataset? or what?
and how can i call their name by their ID?
thank you so much
|
|
|
|
|
Your database should have a seperate table that maps Ids to names.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
you are right!!
thank you
modified 27-Jun-17 6:05am.
|
|
|
|
|
Here is another question
i have a TreeView in my page and i have a table in my database that has these columns: RecordID, CategoryID, CategoryName, Parent ID
how i can bind categories to this treeview that it first show parents then their childs?
thank you
|
|
|
|
|
Farhad Eft wrote: only save their ID in my database
Alternate you can store ID and Value in an XML file if it is a fixed number of Items and the number of items are not going to change often. Reading from the XML file will be bit faster than Querying against the Database.
Regards J O H N
"Even eagles need a push." David McNally
|
|
|
|
|
thank you jon
but how can i show them in treeview?
that it shows parent categories first then their childs
|
|
|
|
|
hi
i'd like to know how can i add a counter to reapeater control's rows
like this:
1. user1
2. user2
3. user3
...
thank you
|
|
|
|
|
Use a variable in the code behind and access it via a property that increments it
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Alternative to christian's suggestion
<%# Container.ItemIndex + 1 %>
|
|
|
|
|
i want to select a folder or a directory through folder browser in asp.net
|
|
|
|
|
You can't, no such thing exists in HTML, and that means the only way to do it, is to write a browser plug in, which is code that your users have to install, and will not be anything to do with ASP.NET.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi Parwej,
thanks for reply, But where this control will get added ?
i want to add this control at specific position .
Thanks and Regards
Sandeep
If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "
|
|
|
|
|
Then put the panel on that position and add into that panel.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
|
Web.sitemap should contain the URL of the page where sitemap control resides
|
|
|
|
|
hi,
Thanks ....i got it..
alex.
|
|
|
|
|
Don't delete your post, that just sucks.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi Everyone,
I am using a web part in a page for the first time.To try how it works i did in a sample page where i first added a webpart manager and a webzone with a label control with some text.
When i try to run i get a run time error saying
"When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"
I dont have sql server in my local machine but should it be needed.I am not trying to connect to database. Then why i couldnt run.
Kindly clarify me
-- modified at 3:28 Wednesday 3rd October, 2007
Thanks,
Srikanth
|
|
|
|