C / C++ / MFC

Re: Reading And Writting Files to Access Database using ADO

31-Jul-06 11:16

Check the database table and make sure the filename isn't null. If it isn't, make sure that your recordset actually has valid data in it when you get to that point (you might have to call MoveNext or MoveFirst to get it properly initialized).

If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week

Zac

Christopher Stratmann31-Jul-06 23:50

Re: Reading And Writting Files to Access Database using ADO

31-Jul-06 23:50

I checked the other fields and they are not null. The file id is 3 and the filename is "temp.txt". But for some reason the CLongBinary Field is null?

Chris

Zac Howland1-Aug-06 3:46

Re: Reading And Writting Files to Access Database using ADO

1-Aug-06 3:46

The LongBinary data is null in your program or in the actual database? Check to make sure there is actually data in that field in the database (if it is null in the database, your program has no hope of having a non-null value :P).

If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week

Zac

Christopher Stratmann1-Aug-06 4:22

Re: Reading And Writting Files to Access Database using ADO

1-Aug-06 4:22

Thank you for all your responses. I really appreciate the help...

I don’t think the data in the database is null. If I try to store a null value into the database I get an error because the field is required and will not allow null values to be stored in the database in this field. Have any other possibilities?

Chris

Zac Howland1-Aug-06 4:40

Re: Reading And Writting Files to Access Database using ADO

1-Aug-06 4:40

The only other thing I can suggest is to search for issues with ADO and BLOBs. I don't remember having issues with them in the past, but it has been a while since I used them.

If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week

Zac

Christopher Stratmann1-Aug-06 7:58

Re: Reading And Writting Files to Access Database using ADO

1-Aug-06 7:58

Thanks for all the help....

Chris

Christopher Stratmann4-Aug-06 2:09

4-Aug-06 2:09

I have great news. I finally figured it out. The problem was neither storing the file into the data nor getting the file out of the database. The problem was in my function to retreive the file out of the database I overloaded the = operator to copy RS_FILEs to each other and didn't copy a CLongBinary to the new CLongBinary. After doing this everything works perfectly.

Chris

wininet issue

EpicYeti31-Jul-06 8:20

EpicYeti

31-Jul-06 8:20

Hello,

I'm having an issued figuring out how to use wininet to post form data to a website. So far I've been able to connect, send requests, and then read the result. However, I cannot seem to send form data to the website, and then read the resulting html the server sends back., (I.E. filling out the search form on the codeproject website.) I'm using the MFC version of wininet.

I connect:

CHttpConnection* pHttpConnection = sess.GetHttpConnection("www.codeproject.com");

sess is the CInternetSession object.
Then I create a request:

CHttpFile* pFile = pHttpConnection->OpenRequest("POST", "/");

CString header = _T("Content-Type: application/x-www-form-urlencoded");
CString mdata = _T("Search=wininet help");
		
pFile->SendRequest(header, header.GetLength(), (LPVOID)(LPCTSTR)mdata, mdata.GetLength());

When I do a pFile->Read() however, all i have received is the codeproject homepage, not the result from entering "wininet help" into the search form. Do I need to format the header differently? Or am I not requesting the correct object with OpenRequest? What am I missing?

Any help on this would be much appriciated. I'm new to wininet, and to writing internet client applications, so please bear with me, heh.

Thanks.

Zac Howland31-Jul-06 9:11

31-Jul-06 9:11

epicyeti wrote:
CHttpFile* pFile = pHttpConnection->OpenRequest("POST", "/");

Last time I checked, there was no action associatd with the root/index for CP. I believe you want it to read:

CHttpFile* pFile = pHttpConnection->OpenRequest("POST", "/info/search.asp");

If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week

Zac

EpicYeti31-Jul-06 9:52

EpicYeti

31-Jul-06 9:52

Ok, so the object parameter(the second one) of OpenRequest should be the Action that is in the form. Do I need to parse the html to find this or is there an easier way to enter the form data? Also, how should the form data that i want to enter be formated? I tried:

CString mdata = _T("Search=wininet");

but it didn't seem to work.

btw, I like your sig.

Zac Howland31-Jul-06 9:57

31-Jul-06 9:57

The second parameter to OpenRequest will be an executable (cgi script, asp page, dll, etc). You will need to parse the HTML to see what fields they have (you can use a GET request on "/" to do that). Its been a while since I used POST in the raw form, but it should be something like "target=wininet" (the name of the form is "Search", but the field you are concerned with is named "target"). If there are multiple fields, they should be separated by a "&" (e.g. "field1=value&field2=another%20value ... etc").

If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week

Zac

EpicYeti31-Jul-06 10:25

EpicYeti

31-Jul-06 10:25

Sweet, thanks a lot man. I might have more questions, but i'm good for now.

Problems with Dialog Buttons

Lucky the code machine23-Feb-08 5:55

Lucky the code machine

23-Feb-08 5:55

Hi, I have tried to use the result of your posts, but it doesn't seem to work. Could you please take a look and point me in the right direction?

http://www.codeproject.com/script/Forums/View.aspx?fid=1647&msg=2437807[^]

Lucky

kitty531-Jul-06 6:34

kitty5

31-Jul-06 6:34

I've created a Dialog that after some input collects data until the buffer is full or the user click on the Stop button.

The problem I'm having is I have a while loop the does the data collection code and once my gui has entered this loop all buttons in the dialog box have no functionality... Mad | :mad:

(I can't click on anything). How would I check to see if the user has clicked on the "stop" button?
At 1st I thought maybe:

<br />
while( ... || ... || (m_nStopBtn.GetCheck() )<br />
{<br />
...<br />
}<br />

but that didn't work since the gui won't let me click on the stop button...

What WTF | :WTF:

could I be doing wrong?

Thanks,

Kitty5

toxcct31-Jul-06 6:40

31-Jul-06 6:40

you shouldn't put huge processes into the GUI thread...

move that loop into a worker thread to avoid the GUI to be frozen

TOXCCT >>> GEII power

[VisualCalc 3.0 updated ][Flags Beginner's Guide new! ]

Zac Howland31-Jul-06 6:45

31-Jul-06 6:45

You beat me to that answer :P

Also, make sure you use proper synchronization objects when doing this (do NOT just try to check a boolean variable each iteration of the loop to see if you should stop!).

If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week

Zac

toxcct31-Jul-06 6:47

31-Jul-06 6:47

:->

Zac Howland wrote:
NOT just try to check a boolean variable each iteration of the loop to see if you should stop!

of course

TOXCCT >>> GEII power

[VisualCalc 3.0 updated ][Flags Beginner's Guide new! ]

kitty531-Jul-06 6:48

kitty5

31-Jul-06 6:48

pardon my stupidity but....

Zac Howland wrote:
proper synchronization objects

?

Thanks,

Kitty5

toxcct31-Jul-06 6:56

31-Jul-06 6:56

zac meant that as several threads access the same memory (see my other answer for the beginning of the discussion), two (or more) threads can access and modify the same variable at the same time.

very bad idea !!!

the solution for this is to "synchronize" the objects that are shared to avoid such problems/

google for semaphores and/or mutex for example

TOXCCT >>> GEII power

[VisualCalc 3.0 updated ][Flags Beginner's Guide new! ]

Zac Howland31-Jul-06 8:04

31-Jul-06 8:04

Basically, what you will want is to create a worker thread (as mentioned above). As part of the creation, you will want to pass in a variable that contains a handle to an event (typically, you will want to pass much more than just that, so a structure/class is created to hold everything you need to pass and then you pass a pointer to that object to the thread you are creating). Each iteration (or some on some interval) of your loop, your worker thread will call WaitForSingleObject and check to see if the event is signaled. If it is not, it continues doing its thing. During the whole loop, you should lock the data section you will be writing to using at least one critical section (which is a form of semaphore that Windows gives you). This way, your GUI thread (or any other thread for that matter -- all of which should also be using critical sections to access the shared data) cannot try to read/write to the memory that you are still loading.

If all of that sounds greek to you, read up on multithreaded programming in C/C++ (lots of good articles on here and Google can be a great help as well). Unless you are going to be working with other OS's, you can focus your search to Windows specific articles.

If you decide to become a software engineer, you are signing up to have a 1/2" piece of silicon tell you exactly how stupid you really are for 8 hours a day, 5 days a week

Zac

kitty531-Jul-06 6:45

kitty5

31-Jul-06 6:45

I'm new with creating MFC Application GUIs... please pardon the stupid question that follows....
What do you mean when you say:

toxcct wrote:
move that loop into a worker thread to avoid the GUI to be frozen

?
Do I create a separate class for the worker thread and have the GUI call it?
The while loop is using member variables of the GUI...(i.e. checking to see whatever user inputs are.

thanks so much,

Kitty5

toxcct31-Jul-06 6:52

31-Jul-06 6:52

actually, the code is already executing in a thread (threads are some executing parts managed by the system). when you put the loop in the event handler, the execution leaves the event handler only when the loop exits and all the instructions where executed.
the problem with suc a design is that other event handlers (such as a button click - yeah, your stop for example) are pushed in the application events stack, but not poped until the current event is not finished.
then, what you can do for that is saying to the system that the loop will be executed in parallel. i mean, the event handler starts the loop, but doesn't wait for its end.
the system doesn't bother if the loop is using member variabless or not, because threads of a same process share the same memory...

TOXCCT >>> GEII power

[VisualCalc 3.0 updated ][Flags Beginner's Guide new! ]

Justin Tay31-Jul-06 7:15

Justin Tay

31-Jul-06 7:15

I think you meant to say queue instead of stack Wink | ;)