Database

FirstPrevNext

Re: Syntax error in my simple UPDATE query!!!! David Stone27-Oct-02 19:56 David Stone 27-Oct-02 19:56  *Gets quiet and stares* You will now find yourself in a wonderous, magical place, filled with talking gnomes, mythical squirrels, and, almost as an afterthought, your bookmarks -Shog9 teaching Mel Feik how to bookmark Re: Syntax error in my simple UPDATE query!!!! SimonS27-Oct-02 22:01 SimonS 27-Oct-02 22:01  Are you sure that Password and User aren't both keywords? Maybe try putting [] around those words and retrying the query. Cheers, Simon "Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002) Re: Syntax error in my simple UPDATE query!!!! Rickard Andersson2028-Oct-02 2:05 Rickard Andersson20 28-Oct-02 2:05  Keywords... hm.. you mean 'Password' and 'User' could be reserved? but when I think back they can't... because I read from the database when the user is trying to log on to a protected webpage (I store username and password in the database). So.... Daaah!!! Rickard Andersson@Suza Computing C# and C++ programmer from SWEDEN! UIN: 50302279 E-Mail: nikado@pc.nu Speciality: I love C#, ASP.NET and C++! Re: Syntax error in my simple UPDATE query!!!! Rickard Andersson2029-Oct-02 2:48 Rickard Andersson20 29-Oct-02 2:48  SimonS wrote: Maybe try putting [] around those words and retrying the query IT WORKS!!!!!!!!!!!! Thank you SO MUCH!!! Rickard Andersson@Suza Computing C# and C++ programmer from SWEDEN! UIN: 50302279 E-Mail: nikado@pc.nu Speciality: I love C#, ASP.NET and C++! Re: Syntax error in my simple UPDATE query!!!! SimonS29-Oct-02 9:39 SimonS 29-Oct-02 9:39  Sure, glad it helped. In future, swop the roses for pics of AnnaK. Cheers, Simon "Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002) Re: Syntax error in my simple UPDATE query!!!! Vasudevan Deepak Kumar29-Oct-02 3:05 Vasudevan Deepak Kumar 29-Oct-02 3:05  Hi Rick, The way Access JET database gives error messages can be at times confusing. When you misspell parameters it will say as 'Too few parameters. Expected x' where x can be no. of parameters misspelt. Have a look at the following to ascertain the type of error and whether the file/directory where the MDB is located is also writeable(this if fails gives the message 'Operation must use an updateable query') http://www.brinkster.com/GeneralDatabaseGuide.asp http://www.brinkster.com/PremiumDatabaseGuide.asp The above are actually a hosting providers' FAQ. However you can filter out those stuff related to keeping MDB over there and take the content that befits your needs and concern. I have an article called WebSQL for ASP.NET. Perhaps you can download that and put in your query over there and have a preview of the same. Either you can view the WebSQL for ASP.NET Article from the 'articles from this author' link or you can follow this link to WebSQL sourcecode. http://www15.brinkster.com/deepaknet/sourcescripts/websqlnet.htm It is just about 4 kb and has an ASPx page and a codebehind .cs With WebMatrix, I think you may need to do some CTRL+C and CTRL+V from .cs to .aspx block so that WebMatrix server JITs the code at runtime, rather than depending on the compiled bin folder which WebMatrix might not support. Hope this solves your problem. deepak Re: Syntax error in my simple UPDATE query!!!! Vagif Abilov4-Nov-02 0:43 Vagif Abilov 4-Nov-02 0:43  What database are you using? "User" is reserved keyword in SQL Server and may not be used without brackets ([User]). Good practice with SQL Server: use brackets with all table/column names. Vagif Abilov MCP (Visual C++) Oslo, Norway Hex is for sissies. Real men use binary. And the most hardcore types use only zeros - uppercase zeros and lowercase zeros. Tomasz Sowinski Re: Syntax error in my simple UPDATE query!!!! Rickard Andersson204-Nov-02 3:10 Rickard Andersson20 4-Nov-02 3:10  I'm using Access 2000. But it's cool man, I've solved the problem, or SimonS solved the problem! Rickard Andersson@Suza Computing C# and C++ programmer from SWEDEN! UIN: 50302279 E-Mail: nikado@pc.nu Speciality: I love C#, ASP.NET and C++! How to compact and repair database? LukeV26-Oct-02 7:10 LukeV 26-Oct-02 7:10  There's CDaoWorkspace::CompactDatabase() for MFC but is there a way to do it with OLE DB/ATL ? Thanks! --------------- Concentrating on Ideas http://www.edovia.com Re: How to compact and repair database? Philip Patrick26-Oct-02 9:02 Philip Patrick 26-Oct-02 9:02  You can use JRO for this. Create an instanse of "JRO.JetEngine" and call its function CompactDatabase (look in MSDN for more information on this function) Philip Patrick Web-site: www.stpworks.com "Two beer or not two beer?" Shakesbeer Edit an Access DB on an internet server using a WinForms DataGrid Ikke24-Oct-02 9:00 Ikke 24-Oct-02 9:00  I know how to create a winform with a DataGrid which enables the user to change values in an Access DB, but now this DB is stored on a server, and I don't know how to create an OleDbConnection to this DB (in C#) because you can't use URLs in the constructor Can someone please help me out? Thanks, Nicolas Re: Edit an Access DB on an internet server using a WinForms DataGrid Mazdak24-Oct-02 23:51 Mazdak 24-Oct-02 23:51  Isn't it possible to do it as web service? Mazy "If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"Kryptonite-3 Doors Down Re: Edit an Access DB on an internet server using a WinForms DataGrid Ikke25-Oct-02 5:41 Ikke 25-Oct-02 5:41  Yes, I'm sorry, but I found a good article on this subject in the VS.Net Walktroughs ("Creating a distributed application"). It uses SQL Server, but that's not really a big prob . THX, Nicolas Inserting spaces into TABLE creation José Luis Sogorb24-Oct-02 3:20 José Luis Sogorb 24-Oct-02 3:20  Is it possible to include spaces when you create a table sSql="CREATE TABLE Graph (Date TEXT, Hour NUMBER,Temp_ºC NUMBER)"; For instance: Temp ºC instead of Temp_ºC Thanks Re: Inserting spaces into TABLE creation Paul Watson24-Oct-02 4:15 Paul Watson 24-Oct-02 4:15  José Luis Sogorb wrote: sSql="CREATE TABLE Graph (Date TEXT, Hour NUMBER,Temp_ºC NUMBER)"; For instance: Temp ºC instead of Temp_ºC Yes, enclose the "invalid" table name with [ and ] e.g. sSql="CREATE TABLE Graph (Date TEXT, Hour NUMBER,[Temp ºC] NUMBER)"; Just also remember when you reference that table to put the [ and ] in. (You can use this technique for reserved table names as well, e.g. Order must be used as [Order]. Paul Watson Bluegrass Cape Town, South Africa Ray Cassick wrote: Well I am not female, not gay and I am not Paul Watson Best way of doing this (ADO) Jeremy Pullicino24-Oct-02 2:31 Jeremy Pullicino 24-Oct-02 2:31  Hello, i have a problem that I am sure anyone who writes database Apps has come across. i am looking for the most elegant solution usnig ADO and an access MDB file, via C++ I have been working with ADO for quite a while now, but I am still unsure of the best way to do this. I have a table which stores values from an email: TO, FROM and SUBJECT. The TO field could contain multiple email addresses. Currently I am storing them in a string, seperating each address with a comma. This method works, but has these (and other) drawbacks: 1) When storing a list of emails, I must first format a string, sperating the emails with a comma 2) When Retrieving the list, I need to read the entire field and parse out the results into an internal list 3) SQL queries, for example, to check if an email exists get a bit complicated. So, the question is, what alternative methods do you DB experts recommend? As usual, thanks in advance, Jeremy. Jeremy Pullicino Professional C++ Developer Done any hacking lately? Re: Best way of doing this (ADO) Mazdak24-Oct-02 2:35 Mazdak 24-Oct-02 2:35  I think it is better to make new table for emails and make relation with other tables. Mazy "If I go crazy then will you still Call me Superman If I’m alive and well, will you be There holding my hand I’ll keep you by my side with My superhuman might Kryptonite"Kryptonite-3 Doors Down Re: Best way of doing this (ADO) Ed Gadziemski24-Oct-02 4:05 Ed Gadziemski 24-Oct-02 4:05  Create a separate table for the TO entries. It would need just a primary key and the TO value. Each row would contain one addressee. Change the TO field in your original table to be a foreign key that points to the new TO table. Oracle Data Provider Johan Lombaard23-Oct-02 23:55 Johan Lombaard 23-Oct-02 23:55  Has anybody used the .NET data provider for Oracle ? How did you find it ? Johan Lombaard Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein Re: Oracle Data Provider Vasudevan Deepak Kumar29-Oct-02 1:57 Vasudevan Deepak Kumar 29-Oct-02 1:57  Hi Johan, Microsoft has released Oracle .NET Data Provider just recently. I have not tried them yet, but with some disgusting experience with OleDB Provider from IBMDADB2 driver and System.Data.OleDB, I have tried moving it to Microsoft.Data.ODBC. The transition was smooth and only one file needed to change. Perhaps you can try Microsoft.Data.Odbc since it has much stable implementation perhaps. deepak Re: Oracle Data Provider Johan Lombaard29-Oct-02 2:03 Johan Lombaard 29-Oct-02 2:03  Thanks deepak. Since I posted my message, I've implemented the Oracle Data Provider in a data import app. It works like a charm, and is 4X faster than the oledb provider in some cases. Johan Lombaard Only two things are infinite, the universe and human stupidity, and I'm not sure about the former - Albert Einstein Multiple Inserts in a Stored Procedure RJS23-Oct-02 11:32 RJS 23-Oct-02 11:32  Is there any way to do a multiple inserts in a stored procedure in SQL2000? Please help. Thanks. Re: Multiple Inserts in a Stored Procedure Nick Parker23-Oct-02 12:50 Nick Parker 23-Oct-02 12:50  RJS wrote: Is there any way to do a multiple inserts in a stored procedure in SQL2000? You could write a while loop inside the stored procedure, there are many ways of doing something like this. Nick Parker May your glass be ever full. May the roof over your head be always strong. And may you be in heaven half an hour before the devil knows you’re dead. - Irish Blessing Re: Multiple Inserts in a Stored Procedure SimonS23-Oct-02 17:44 SimonS 23-Oct-02 17:44  Can you give more details? Are these just INSERTS into multiple tables? Are the INSERTS dependent on each other? Cheers, Simon "Sign up for a chance to be among the first to experience the wrath of the gods.", Microsoft's home page (24/06/2002) Re: Multiple Inserts in a Stored Procedure RJS24-Oct-02 4:17 RJS 24-Oct-02 4:17  Simon, thanks for the reply. The scenario is like this: I have (let's say) 3 records or more in my .net page. Example: "John", "123 Anywhere", "City1" "Rudy", "345 Anywhere", "City2" "Tom", "335 Anywhere", "City2" ... ... Is it possible to do a multiple inserts in a stored procedure to save those 3 records or more in a table? If so, how do I pass the parameters since I will not know what is the maximum records that will be sent at once? Thanks.

Last Visit: 31-Dec-99 18:00     Last Update: 2-May-24 14:11 Refresh ᐊ Prev1...2398239924002401240224032404240524062407 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.