|
How do write WHERE clause in my SELECT query it is giving me error like "data type mismatch in expression syntax"
My Q is "SELECT subcat_id,subcat_name FROM temp_subcat WHERE cat_id = 'get_cat'"
where get_cat is long int variable and cat_id field of DB is also long Integer type.
I thing writing 'get_cat' is not sufficient and i should use some other syntax like '".get_cat."' in PHP i used to write, but again its not working and i am not sure, plz help me out with this simple problem. asfdsf
San
San
|
|
|
|
|
I am not sure, but how about trying get_cat without single quotes like:
"SELECT subcat_id,subcat_name FROM temp_subcat WHERE cat_id = get_cat"<br />
Best Regards,
Suman
|
|
|
|
|
Yes that is good approach, thanks, in fact i tried it
"SELECT subcat_id,subcat_name FROM temp_subcat WHERE cat_id = get_cat"
and the response from program changed than before but it is throwing exception now like --> "Too few parameters, Expected 1"
From this it seems SQL parser is not counting the get_cat parameter, not sure
Thanks again, but plz check if we could figure out this Exception now
San
San
|
|
|
|
|
|
How do write WHERE clause in my SELECT query it is giving me error like "data type mismatch in expression syntax"
My Q is "SELECT subcat_id,subcat_name FROM temp_subcat WHERE cat_id = 'get_cat'"
where get_cat is long int variable and cat_id field of DB is also long Integer type.
I thing writing 'get_cat' is not sufficient and i should use some other syntax like '".get_cat."' in PHP i used to write, but again its not working and i am not sure, plz help me out with this simple problem.
San
San
|
|
|
|
|
i want to use single dialog for all tabs in tab control.but the value of controls on dialog is vary for each tabs.how to do this.
or
How to create a dyanmic dialog with controls.
|
|
|
|
|
u can make the visible property false where you dont require and visible true where u want that perticular control
|
|
|
|
|
how to add dynamic dialog to tab control.
|
|
|
|
|
now i got material for create a dynamic dialog.In that material dynamic dialog is created when button is clicked.i want to do this with tab .how to do this.
|
|
|
|
|
http://www.codeproject.com/buttonctrl/cxskinbutton.asp
in this code how can one call the button clicked function on pressing enter
vimarsh
|
|
|
|
|
Did you ask of writter this article?
|
|
|
|
|
|
First, when you need to post a question, put a relevant title.
Also, it would be nice to explain the problem more in detail. I had to read your answer here[^] to see what the problem was. The better you describe what the problem is, the more chances you'll get to have an answer.
By the way, the problem has nothing to do with the skin button, the problem would be the same with a standard button.
To avoid that the dialog closes when you press enter, see here[^].
|
|
|
|
|
Hi all,
can u suggest me what are the ways of getting a vertical scroll bar in the tab control.
The scroll bar should be dynamic i.e the scroll bar should be visible only when the size of the tab is more.for normal size the scroll bar should not be visible.
Thanks
Sireesha
|
|
|
|
|
how does the size of the tab increases?
|
|
|
|
|
For each tab item i have a dialog.when the size of this dialog is increased it should have vertical scroll bar in it. the size of the tab control should not be changed when the size of the dialog is increased.
Thanks,
Sireesha
|
|
|
|
|
Hi all,
can u suggest me what are the ways of having a vertical scroll bar in tab control.
The scroll bar should be dynamic i.e the scroll bar should be visible only when the size of tab is more.for normal size it should not be visible
Thanks
Sireesha
|
|
|
|
|
Hi
I would like to know whether SDK is available in VS2005. If yes how could I select that at the time of installation
|
|
|
|
|
If you're talking about the Platform SDK or the Windows SDK, they come with utilities that add the SDK's directories to the VS options, so that future builds will use the files in the SDK.
|
|
|
|
|
Hey. I was wondering if some one could help me with this article.
http://www.codeproject.com/internet/akashhttpproxy.asp
Could some one please download it and give me an updated code that I would use to communicate to the smtp server? (send helo, receiving the respone, send mailfrom, etc) This would be greatly appreciated.
|
|
|
|
|
I have an MDI Document/View App which (simplified) has 1 MyDocument class and 2 view classes. MyScrollView (derived from CScrollView) and MyFormView (derived from CFormView. Usually MyScrollView will be Maximized and occasionally MyFormView will be activated.
MyFormFrame (from CMDIChildWnd) is used to contain MyFormView and overrides PreCreateWindow to remove WS_MAXIMIZEBOX from the window style. MyFormFrame also implements OnCreate and OnGetMinMaxInfo in order to restrict the MyFormFrame to the exact fit for the MyFormView dialog resource.
With these preconditions (MyScrollView maximized and MyFormView maximize box disabled), when MyFormView is activated, MyScrollView is restored to its original non-maximized state (this is unwanted behaviour).
If I don't remove WS_MAXIMIZEBOX (from MyFormFrame) then MyFormView is activated with no caption at the top left of the MDICLIENT (and thus can't be draged).
Does anyone know if/how I can acheive the desired behaviour (MyFormView activated with caption on top of maximized MyScrollView)?
Many thanks
John
|
|
|
|
|
I want to handle notification when i click check box in treeview, but i don't see any notification message which allows this.
Beside this - i try to use OnClick event - but when i use method GetSelectedItem i getting wrong HTREEITEM of the item.
Thanks for any help.
|
|
|
|
|
|
Yanshof wrote: I want to handle notification when i click check box in treeview,
You need to handle WM_NOTIFY, notification code will be NM_CLICK.
Refer this[^].
|
|
|
|
|
:-DHello!!Everyone!In MFC ,how can I move a small bitmap to another place!And I can also drag the side edge to change the dimension of the bitmap! Thank you !
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
