|
The error message that VS2003 shows is as follows.
ERROR [42000] [MySQL][ODBC 3.51 Driver][mysqld-5.0.41-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.Text' at line 1
Line 92: Dim ad As New OdbcDataAdapter(cmd)
Line 93:
Line 94: ad.Fill(ds)
Line 95:
Line 96: Me.ListBox2.DataSource = ds
|
|
|
|
|
Look more closely at the select statement you're constructing...
"SELECT * FROM myTable where Professions = 'ListBox2.Items(i).Text' "
You are not appending the Text property of ListBox2.Items(i), the WHERE clause is being set to the string literal 'ListBox2.Items(i).Text'.
Rhys
"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"
They say a little knowledge is a dangerous thing, but it's not one half so bad as a lot of ignorance."
Terry Pratchett
|
|
|
|
|
That's exactly what I wanted. The select statement is supposed to select my table where the name of the profession is equal to the text of the list item being selected. I'm trying to display the content of the field Resume Where the profession field is equal to list item being selected.
|
|
|
|
|
Look at it again. The query you're sending is;
SELECT * FROM myTable where Professions = 'ListBox2.Items(i).Text'
NOT
SELECT * FROM myTable where Professions = 'ExampleProfessionFromListBox'
Rhys
"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"
They say a little knowledge is a dangerous thing, but it's not one half so bad as a lot of ignorance."
Terry Pratchett
|
|
|
|
|
Hi, in my database table the Resumes field stores resumes in blobs and each resume in the Resumes field has a corresponding profession which is stored in the Professions field. I am trying to enable users to search for resumes by selecting a single profession or many professions in the listbox. The select statement is supposed to select the resumes in mytable where the Professions field has the profession(s) that is/are equal to the text of the listitem(s) that the user has selected. Is this the wrong way to go about it? If it is how should I utilize the For-Next loop so that the listitem selected matches the profession in the Professions field? I tried your example but it didn't work, perhaps I did not know how to implement your example correctly. Please elaborate a little more and give another example. This is what I had done after seeing your example
("SELECT * FROM Contenttbl where Professions = 'ListBox2.Items(i).Text from ListBox2'")
Thank you again for your help.
-- modified at 14:39 Tuesday 10th July, 2007
|
|
|
|
|
You need to get the value of the Text property, (which is already a string type), and get that into your Sql string. Ideally you'd utilise stored procedures and pass in parameters, but we won't go there yet.
Your problem is here;
= 'ListBox2.Items(i).Text from ListBox2'
All this does is put the string value 'ListBox2.Items(i).Text from ListBox2' as your where clause. The statement;
ListBox2.Items(i).Text
...will get you the string value you want.
Try the below, (I usually use c# so it may not be syntactically spot on), and look at the difference between what you've got;
"SELECT * FROM Contenttbl where Professions = '" & ListBox2.Items(i).Text & "'"
Rhys
"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"
They say a little knowledge is a dangerous thing, but it's not one half so bad as a lot of ignorance."
Terry Pratchett
|
|
|
|
|
Thank you so much for responding, I have tried your suggestion and it worked.
-- modified at 2:07 Wednesday 11th July, 2007
|
|
|
|
|
Sorry if this sounds patronising, but I'd say the important thing here is to see and understand the difference in both statements so do take the time to make sure you do, it'll be far more helpful in the long run 
Rhys
"The trouble with having an open mind, of course, is that people will insist on coming along and trying to put things in it"
They say a little knowledge is a dangerous thing, but it's not one half so bad as a lot of ignorance."
Terry Pratchett
|
|
|
|
|
Hi,
I have a textbox which gets value from a calender control.To avoid users from manually typing I have diabled the textbox,The problem is on Postback the Textbox value i.e the date value is getting cleared.
I have also tried it using Readonly Property same problem.
Can any one please give me a solution ,
Thanks is Advance.
Archana
|
|
|
|
|
I thing you have you set the autopostback property of textbox set to false
cheers
|
|
|
|
|
No ,I didnt set the Autopost back,Since Im getting the value from calender control the page is automatically getting refreshed.
|
|
|
|
|
Set the autopostback = false in aspx page check it
|
|
|
|
|
|
View state is maintaining value on postbacks. So try disabling viewstate for the textbox.
|
|
|
|
|
How did you disable this textbox? There is a reason why i ask this question. There are some differences between disabling textbox explicitly and disabling parent container control (eg: Panel or DIV).
|
|
|
|
|
This link said that ~
Question 3. Why all data from web controls within the disabled panel has been lost during the postback?
It’s pretty strange. In window-based application, we only need to disable the panel if we want to disable all controls inside this panel. But we can’t do like that in web development. ASP.NET doesn’t keep the viewstate of the controls if the panel is disabled so that all data in those controls within disabled panel will be lost during the PoskBack.
The solution for this problem is that enable or disable each each and every controls inside the disabled panel. Enable explicitly.
Scott Mitchell wrote very good article about this problem and solution in this blog.. You may check his article “Panel Weirdness” here.
|
|
|
|
|
I want to clear a session by calling an assembly, How i deduct browser close button in javascript or vb.net. When the user click on the close button of browser i want to call a method in code behind.
Thanks
Mahesh
|
|
|
|
|
Detecting browser unload event.
- Use onunload event of body tag to detect the closing of browser.
Calling Server-side function from client-side script
- Add a server-side hiddenfield to your page.
- Write the code (eg: clearing a session) in the change event of this hiddenfield.
- Grab this field and put some value to this hidden field from Javascript. As soon as the value is changed in this hiddenfield, the server-side event will be fired/invoked so that the code for clearing a session will be run.
Hope it would help.. Let me know if you are not clear.
|
|
|
|
|
Michael,
Thanks for reply. Well i write a function in javascript and call that function like that from inside the body tag onunload ="CloseBrow();" inside the CloseBrow how i detect when user click on Close button of browser, i must have to check that since page is unloaded every time when user move back and forth. I user some script inside that function "if (screenTop > 9999)" but this is working in some browser and not working in another browser.
thanks and regards
mahesh
|
|
|
|
|
Yeah. You are right..
Have you tried this?
|
|
|
|
|
Yes I tried it.
I tried this one also
if (window.event.clientX < 0 || window.event.clientY < 0)
This is working for IE in some machine and not for others.
And I place a html button runat="server" whose display style is none after check this if (window.event.clientX < 0 || window.event.clientY < 0)
i fired the button click from javascript and call a procedure in code behind, like that window.document.hidBut.click();
Pls let me know if there is another way to handle the close button of browser.
regards
mahesh
|
|
|
|
|
hi,
does anyone out there knows any website that offers tutorial on how to include map in a website.
that map could be from google map, yahoo map, msn, or anything.
thanx
|
|
|
|
|
Please Google it.
Here is "Google Maps Control for ASP.NET 2.0 - ScottGu's Blog"
Hope it helps.
|
|
|
|
|
thanx a lot!!! i really, really, really appreciate the link...
another question, if you dont mind...
do you know any other website that has free tutorial and software on creating maps..
i've googled it a lot, and i always get the same websitessss.
i'm trying to find a suitable (easy and basic) tutorials and software but cant find..
its really frustrating...
|
|
|
|
|
Hi,
I am having a dilemma on what to do. Here is my situation.
I have a website which every page will have a tree view on the left and the content on the right.
I do not want to use iFrame or Frame as when I refresh, it will bring the user back to the main page and also some browser might not support frame. Another thing is the page title on the top left corner of the browser does not change when I go to another page with a different title.
I wanted to have something like PHP's includes or something which can solve my above problem, I heard of CSS but CSS will still need me to include the tree view in every page by myself.
I need some advice on this.
Thanks in advance.
J Liang
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
