Re: using variables in insert query for Access - C / C++ / MFC Discussion Boards

Re: using variables in insert query for Access

Cedric Moonen15-Jun-06 23:14

15-Jun-06 23:14

And, did you check with your debugger to see if the string is properly 'spelled' before calling execute ? If you made spelled incorrectly, I cannot help you. One thing you have to try: just for a test, execute the same string but hard-code it (so, write it completely yourself with the url and everything). If you get an exception, then it means that the string is not properly spelled.

Cédric Moonen
Software developer

Charting control

Re: using variables in insert query for Access

shuchigo_jane15-Jun-06 23:17

shuchigo_jane

15-Jun-06 23:17

worked jus fine with a hard coded string...
prob arose only wen we wanted to insert a value from a variable..

Re: using variables in insert query for Access

Cedric Moonen15-Jun-06 23:19

Cedric Moonen

15-Jun-06 23:19

Geez, third time I ask you to use your debugger ! Check the format of your string if it matches exactly the same format that your hard-coded string.

Cédric Moonen
Software developer

Charting control

Re: using variables in insert query for Access

David Crow16-Jun-06 3:03

David Crow

16-Jun-06 3:03

Try:

string.Format("INSERT INTO(URL,Object_size,No_of_accesses,Transfer_cost,Group_no,Hvalue,Location) VALUES(\"%s\",7,6,8,\"hi\")", url);
// check the value of <code>string</code> at this point
m_pCommand->CommandText = string;

"The largest fire starts but with the smallest spark." - David Crow

"Judge not by the eye but by the heart." - Native American Proverb

Re: using variables in insert query for Access

Viorel.15-Jun-06 22:58

Viorel.

15-Jun-06 22:58

I think you have to investigate the CreateParameter and Parameters members of Command object.

I suppose you have to use "@url" in the command text, and then use something like this:

_ParameterPtr param = m_pCommand->CreateParameter("url", adVarChar, adParamInput, url.length(), url.c_str());
m_pCommand-> Parameters->Append(param);

This is just my guess.

Re: using variables in insert query for Access

Milton Karimbekallil15-Jun-06 23:56

Milton Karimbekallil

15-Jun-06 23:56

Below given is the fixed code. Copy this and try.

<br />
CString url="asdf";<br />
_Commandptr m_pCommand;<br />
m_pCommand.CreateInstance(__uuidof(Command));<br />
<br />
CString strSql = _T("INSERT INTO wcs(URL,Object_size,No_of_accesses,Transfer_cost,Group_no,Hvalue,Location) VALUES('") + url + _T("',7,6,8,'hi')");<br />
<br />
m_pCommand->CommandText = _bastr_t(strSql);<br />
<br />
m_pCommand->CommandType=adCmdText;<br />
m_pCommand->ActiveConnection = m_pConnection;<br />
_variant_t vRecords;<br />
m_pCommand->Execute(&vRecords,NULL,adCmdText);

cheers...milton kb

Re: using variables in insert query for Access

shuchigo_jane16-Jun-06 0:02

shuchigo_jane

16-Jun-06 0:02

cheeeeeeeeeerrrrrrrrrssss.....thanx a bunch...it worked... Smile | :)

Re: using variables in insert query for Access

Viorel.16-Jun-06 1:38

Viorel.

16-Jun-06 1:38

Please note that the solution based on string concatenation sometime will give SQL errors, in another cases will allow someone to manipulate your database in un-authorized manner.

For instance, suppose the url variable is a string that is entered by the user. If he/shi enters "http://www.codeproject.com" everything is fine, but if enter "http://www.codeproject.com?user=’abc’", then your insert operation will fail. (Guess why).

If the user enters something like "’,1,2,3,’bad string’) --", then instead of your 7, 6, 8 and 'hi' values, database will be filled with 1, 2, 3 and ’bad string’ values.

This technique is called SQL injection. It can allow bad people to discover private information like passwords, or even delete the entire database.

You can read about this here:

FileHeader

Rinu_Raj15-Jun-06 20:56

Rinu_Raj

15-Jun-06 20:56

How to obtain file header for a file ?

Thanks in advance
Rin

Re: FileHeader

Hamid_RT15-Jun-06 21:29

Hamid_RT

15-Jun-06 21:29

whats file?

whitesky

Re: FileHeader

Sarath C15-Jun-06 21:35

Sarath C

15-Jun-06 21:35

Be more specific

Sa^Rath.

"Don't Do Different things... Do Things Differently..."

Understanding State Pattern in C++

Re: FileHeader

kakan15-Jun-06 21:42

kakan

15-Jun-06 21:42

There is no such thing as a general file header!

There are general file attributes, you can get them with GetFileSize(), GetFileType(), GetFileTime() e.t.c.

Another thing is that files used by certain applications can have a file header. In that case, the header is specific to the application that created the file in question.

Could someone help me with this?

Syouki_kou15-Jun-06 20:54

Syouki_kou

15-Jun-06 20:54

My Question[^]

Re: Could someone help me with this?

kakan15-Jun-06 21:28

kakan

15-Jun-06 21:28

See my reply
http://www.codeproject.com/script/comments/forums.asp?forumid=186301&select=1534895#xx1534895xx[^]

Re: Could someone help me with this?

Syouki_kou18-Jun-06 15:33

Syouki_kou

18-Jun-06 15:33

This trouble is fixed, thanks kakan Big Grin | :-D

CDialog

Member 303984315-Jun-06 20:08

Member 3039843

15-Jun-06 20:08

How can i change the dialog box background color dynamically. Confused | :confused:

Re: CDialog

Hamid_RT15-Jun-06 20:12

Hamid_RT

15-Jun-06 20:12

you ca use WM_CTLCOLORor WM_PAINT

whitesky

Re: CDialog

Member 303984315-Jun-06 20:18

Member 3039843

15-Jun-06 20:18

But i want to chage the background depending on the color specified dynamically. I am getting an exception when i post the WM_CTLCOLOR message .
Thanks for ur reply,

Re: CDialog

Hamid_RT15-Jun-06 20:24

Hamid_RT

15-Jun-06 20:24

i guess you getting exception because use a brush,yes?
see here maybe it is some helpful to you

<br />
void CAnswerDlg::OnPaint()<br />
{<br />
	CPaintDC dc(this); // device context for painting<br />
dc.FillSolidRect(0,0,GetSystemMetrics (SM_CXSCREEN),GetSystemMetrics (SM_CYSCREEN),<br />
		RGB(53,97,200));<br />
}<br />
--------------<br />
HBRUSH CAnswerDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor)<br />
{<br />
HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);<br />
return (HBRUSH)GetStockObject(WHITE_BRUSH);<br />
}<br />
<br />

whitesky

Re: CDialog

Member 303984315-Jun-06 20:47

Member 3039843

15-Jun-06 20:47

The code was working fine.
But the controls like edit box etc.. are not visible bcoz of FillSolidRect(). How can i solve this problem
Smile | :)

Re: CDialog

Hamid_RT15-Jun-06 21:02

Hamid_RT

15-Jun-06 21:02

Are you sure i test your problem but these are visible i used this code
(editbox,button,radio,..)are visible

<br />
COLORREF Color;<br />
Color=GetDC()->GetBkColor();<br />
....<br />
....<br />
void CAnswerDlg::OnPaint()<br />
{<br />
CPaintDC dc(this); // device context for painting<br />
dc.FillSolidRect(0,0,GetSystemMetrics (SM_CXSCREEN),GetSystemMetrics (SM_CYSCREEN),<br />
Color);<br />
}<br />
<br />
void CAnswerDlg::OnBnClickedButton1()<br />
{<br />
	Color=RGB(53,97,200);<br />
	Invalidate();<br />
}<br />

whitesky

Re: CDialog

Eytukan15-Jun-06 23:09

Eytukan

15-Jun-06 23:09

Though you could do it by these ways, HandlingWM_ERASEBKGND is the right one for it.

<marquee scrollamount="1" scrolldelay="1" direction="up" height="10" step="1">--[ Jig | [Dance]

]--

[My Current Status]

Re: CDialog

Hamid_RT16-Jun-06 0:50

Hamid_RT

16-Jun-06 0:50

but i want to know why he cant show controls its attract for me to find answer for this question (of course i need to see his code that how to use)

whitesky

Re: CDialog

Member 303984317-Jun-06 2:00

Member 3039843

17-Jun-06 2:00

My code is:

BOOL CSliderDlg::OnEraseBkgnd(CDC* pDC)
{

if(m_clr.GetPos()!=0)
{
int color=m_clr.GetPos();
COLORREF clr=RGB(color,color,color);
CRect rect;
GetClientRect(&rect);
pDC->FillSolidRect(&rect,clr);
}

return CDialog::OnEraseBkgnd(pDC);
}

I am calling this function from WM_HSCROLL handler.
m_clr is the slider ctrl.
If there is any mistake in my, let me that mistake.
Thanx. Smile | :)

Re: CDialog

Hamid_RT17-Jun-06 7:11

Hamid_RT

17-Jun-06 7:11

this code it seems not problem i tested this code and it work fine of course without if(m_clr.GetPos()!=0) like this

<br />
BOOL CAnswerDlg::OnEraseBkgnd(CDC* pDC) <br />
{<br />
//int color=m_clr.GetPos();<br />
COLORREF clr=RGB(53,97,200);<br />
CRect rect;<br />
GetClientRect(&rect);<br />
pDC->FillSolidRect(&rect,clr);<br />
return TRUE; <br />
}

and controls are visible you can use WM_CTLCOLOR with a brush and it work and i think it good for you

whitesky

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