?
Solved

Server supports MySQL but client records data in Access

Posted on 2003-03-11
31
Medium Priority
?
574 Views
Last Modified: 2010-08-05
Hi again,

I have another client who is ready to move to a new ISP for their Web hosting for various reasons. I am to choose an ISP for them based on their current and future needs, which are not extensive at the moment.

The ISP I am considering provides cPanel (Linux) with many features that the client would like to take advantage of e.g. phpBB Forum, Shopping Cart, php and MySQL ... just to name a few.  

However, the most important aspect to consider re this client, is that they record some data inhouse using Access and would like this to be available for users to search only.

The problem in moving to the cPanel is that it does not, of course, support Access.  The ISP suggests we go with their Windows2K Advanced package ... but it does not include many of the features the cPanel offers.

I work with Macintoshes and Dreamweaver etc and use Filemaker a little .... but cannot use Access. At the moment I am getting the client to save their small database file in Excel format and then converting this to several html pages so users can search.

I am not very familliar with server side technologies, but is there anyway we can move to the cPanel, and somehow convert or query the Access database file using MySQL .... or maybe evenJavaScript?

Any other suggestions? I would appreciate any feedback or advice on the above.

Thanks very much, Sanengel
0
Comment
Question by:Sanengel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 19
  • 12
31 Comments
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8122200
You wont be able to hit the Access database at all if the web server is linux.  It depends on how/if data is still being added to the Access database.  If the users are still adding data directly into Access, then regular dumps to excel is your only option (I assume users are actually downloading the SS in order to search it, and not searching it via the webpage.)  If the database is pretty small, then I would suggest recreating the whole thing in mySQL and have the users read and write via webpages.
0
 

Author Comment

by:Sanengel
ID: 8124099
Thanks for your feedback.  At the moment I'm having the client save their Access db weekly in Excel, then I convert to html and upload pages to server for their franchisees to search for their results.

The db is small, only one table w/8 fields. It is working fine at the moment, but was just hoping to get it running more effeciently. However, I doubt I can get the client to enter the data via their Web browser .. they will want to continue using Access in house to keep and store their data.

I guess if I learn mySQL and export the Access db weekly, it will at least give their franchisees the facility to search for individual results instead of just viewing an html page with a list of results.  Or, maybe I could incorporate some sort of search on the html page that will pull up individual records or multiples ... would this be possible?
0
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8129171
I saw a few EE articles in the PHP section on how you CAN actually hit an Access database and display results.  See <a href="http://www.experts-exchange.com/Web/Web_Languages/PHP/Q_20347704.html">Q_20347704</a> I think this still poses a problem for you however.  Correct me if I'm wrong... the Access db sits on a local network (drive or share), this means that even when the webpage hits the Access db, it neeeds to hit one that actually sits on the webserver.  Other than that, no matter what kind of data source you have on the webserver you can certainly setup some sort of searching functionality.  there are a bunch of articles in the PHP section on setting up db stuff.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 

Author Comment

by:Sanengel
ID: 8132194
Thanks again DialM4Monkey,

You are right, at the moment the Access db only sits on the local network, not the server. The current server is Unix and the server the client is planning to move to asap is Linux. And, as you initially confirmed, the Access db cannot live on the Linux server.

I've read heaps of the info you noted under PHP on EE, it's great ... I need to keep reading and learning.

In the mean time, which do you think would be the wisest thing to do ....

1. Proceed with the idea of  converting the db to MySQL regularly or as needed. I've just been learning how to do this.

2. Convince the client to pay for a space on a different server to host the Access db and then upload regularly.  (I could still query it from the linux server using PHP or ASP, right?)  This may actually be more cost effecient for them in the long run.

3. Or, I was told I can use a 'free form' search i.e. ... have the client save the db as a tab separated text file (or comma separated) from Access then search each line/record for a target string (just a few characters typed by the user).  If the target is matched use the 'split' method (split the line on the tabs or commas) to turn the line into an array and display it.   Mind you, I'd have to figure out how to actually write/do this!

I guess, in any case, because I doubt I can get the client to enter this data online ..... something will need to be uploaded and/or converted regularly, right?

Your comments please? Oh, and you have the points of course.  However, I'm just not sure ... if I accept your answer above, can we still comment or does it close the question?

Thanks, Sanengel
0
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8136634
Thats cool.  I'm not a points nazi, I just like answering the questions.  so lets keep the thread going until you're satisfied.

I think you're right, in any case you'll have to upload something on a regular basis, either a text file or the db itself.  It seems like the next thing to determine is if your ISP supports COM("access.application").  From there we can decide if we should use Access or a Text file.  After that we can definately set up some sort of search.
0
 

Author Comment

by:Sanengel
ID: 8139784
Thanks, that's nice.

Firstly, re my #2 alternative above, I was told that if on Linux evenusing ASP or IASP, I couldn't attach to an access database even if the db was on another server.

With regard to your suggestion, I had to look up what exactly COM("access.application") was .... is this correct?

"RNAAPP (Remote Network Access Application) is one of those occasionally visible yet mysterious little programs that come with the Microsoft Windows 95/98 operating system. It is part of Windows' Dial Up Networking capability. Users can see it in Windows Explorer as rnaapp.exe. (The exe stands for executable, meaning it's a file that is a program.) RNAAPP can be the source of a problem when trying to get Internet access. It sometimes remains in memory from a previous connection, making the system believe that a connection is already established. "

Anyway, I'm guessing that if the client goes with the Linux server, it won't support this, and if they went with the Win2K, it may not either based on the version (course may not be necessary if they went with this server).  But I will check with the ISP to confirm.

As noted earlier, the client wants to go with the LInux server, but it hasn't been entirely decided yet.
0
 

Author Comment

by:Sanengel
ID: 8140899
OK, just heard back from the ISP and they do support  COM("access.application").

However,  also just got confirmation that the client definitely wants to proceed with the cPanel/Linux server for the other features it offers.
0
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8153224
It sounds like Green lights all around.

My suggestion would be to upload the whole database to the ISP at least 1 time a day.  Then write a few php pages to get the data and allow the users to search the data.

I found another article on EE for PHP/MSAccess stuff http://www.experts-exchange.com/Web/Web_Languages/PHP/Q_20542359.html 

I think the trick with the above sample will be changing the line "$db = "C:\\Program Files\\Microsoft Office\\Office\\Samples\\Northwind.mdb";
" in the section written by carchitect.  you can try using a relative path like "/somedir/mydatabase.mdb" either that or hunt around for a PHP function for converting absolute paths to relative ones (ASP has a function like this called MapPath, works great)

Not sure if you use these guys, but http://www.php.net is as excellent PHP resource.

I did some quick hunting and found "realpath()" this seems to be the function you will need to convert ralative to absolute paths.  I did a google search for "PHP equivalent for MAPPATH" and got lots of hits.

what do you want to do next?
0
 

Author Comment

by:Sanengel
ID: 8156898
DialM4Monkey ... many many thanks for all your efforts. Wow!

However, before I followup on any of your suggestions, I need to clarify something ...

In my last post I mentioned that even though the new ISP said they support COM("access.application") on their Windows server, the client had also just taken a Hosting package with the ISP's Linux server instead.  

So, now doesn't that pretty much exclude being able to upload and hit the .mdb directly?  I was thinking I now had to go the route of converting the Access db to MySQL so we could search it using PHP on the Linux server.

Sorry to be a pain, but is this correct?
0
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8158859
Sangengel -

Just curious, where are you? I'm in Houston, TX

I think we are still OK regarding your point about being on the Linux server.  the COM("access.application") statement is a PHP command for opening an MS Access database.  

I think we're getting the best of both worlds.  If for some reason we cant hit the database directly, then we'll just have to add one extra step in whole process where we export the Access data to some sort of text file and use that as our datasource.  

I'm hoping we dont have to do that, thats why I looked up the COM command.  

Testing our connectivity to the database should be the first thing we do.  Can you construct a page to test that?  If you like I can get you something to get started.

Is PHP something you are interested in learning or are you more interested in just getting this into production?  Because I can steer you in the right direction to research the specifics yourself or I can hunt down some usable code that you should be able to just plug in and go.
0
 

Author Comment

by:Sanengel
ID: 8162276
Hey DialM4Monkey,

I am in Victor Harbor, South Australia (have lived here for many years, but grew up in Kansas & have lots of family and friends all over Texas.)

Anyway, you have been most kind for doing all you've done, and for understanding my limitations and ignorance on the subject. Your optimisim is great, and I'm excited to give what you have suggested a go!

OK, not sure if this makes a difference, but this was the ISP's response when I asked if they support COM("access.application") ....
".COM applications run on Windows servers. We do support them."

To answer your other questions ... Yes, I am interested in learning and understanding more about PHP as I continue to design Web sites, but given time restraints must jump in straight away for now and get the project underway. Once in place, I tend to look at  and study the working code. Helps me learn.  

Anyway, if it's not too much time and trouble, it would be wonderful if you could get me started.

With great appreciation, Sanengel
0
 

Author Comment

by:Sanengel
ID: 8162514
Hey,  

Just had another flash ....

Because my client's new ISP's Hoting fee's are so reasonable and the overall cost factor is not an issue with my client, I'm wondering if maybe I should just go ahead and also get a Windows box to serve the .mdb and ASP pages.

Even though I was kinda anxious to learn a bit about PHP and MySQL, would this be more effecient for the client?  

What do you think?

Cheers, Sanengel
0
 

Author Comment

by:Sanengel
ID: 8163346
Hey,  

Just had another flash ....

Because my client's new ISP's Hoting fee's are so reasonable and the overall cost factor is not an issue with my client, I'm wondering if maybe I should just go ahead and also get a Windows box to serve the .mdb and ASP pages.

Even though I was kinda anxious to learn a bit about PHP and MySQL, would this be more effecient for the client?  

What do you think?

Cheers, Sanengel
0
 
LVL 2

Accepted Solution

by:
DialM4Monkey earned 160 total points
ID: 8166892
Sanegel -

Try this PHP snipit...

<?php

// NEED TO CHANGE DB PATH APPROPRIATELY
$db = realpath("/somedir/somedb.mdb");

$conn = new COM("ADODB.Connection");
$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");

// NEED TO CHANGE SQL STATEMENT APPROPRIATELY
$sql = "SELECT * FROM tablename";
$rs = $conn->Execute($sql);

?>

<table>
<tr>
     <th>Field 1</th>
     <th>Field 2</th>
     <th>Field 3</th>
</tr>
<?php while (!$rs->EOF): ?>
     <tr>
              <td><?= $rs->Fields['Field1']->Value ?></td>
              <td><?= $rs->Fields['Field2']->Value ?></td>
              <td><?= $rs->Fields['Field3']->Value ?></td>
     </tr>
     <?php $rs->MoveNext() ?>
<?php endwhile ?>
</table>

<?php

$rs->Close();
$conn->Close();

?>


make sure it gets placed inside the <body></body> tags and make sure the file has a .php extension.  there are two places we need to make changes.  1) the relative db path, and 2) the correct sql statement.

The column headers are static you you'll need to change those appropriately as well.
0
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8166944
Sanegel -

If you go to a windows/ASP server will you loose some of the cPanel features you mentioned?  If not then we are seriously IN BUSINESS.  I'm about 1000% more effective when it come to ASP.  I do ASP in my sleep.  I understand your point about learning a little more about php (me too!)  but time is always a factor.

I dont get much chance to talk with people from other countries, and I'll understand if the subject is too sensitive, but what is your opinion of the US/Iraq situation?
0
 

Author Comment

by:Sanengel
ID: 8170887
Hey DialM4Monkey,

Yep, if the client moved to a windows/ASP server they would loose many of the features of the cPanel that they want ...

But, what I was actually contemplating was the idea of  "also" getting a windows/ASP server. This new ISP's Hosting fees are very reasonable ($125 Australian p.a. for the basic package whether cPanel or Windows).

So, I was thinking that if overall it helped things run more effeciently ....  $250 p.a. all total would be well worth it to the client. For that matter, they were spending over $550 pa for hosting. And funny thing is, although they were impressed with all that the cPanel had to offer, they weren't really comfortable with the fact that it was so cheap!

I guess I was kinda thinking that then the db wouldn't have to be converted all the time and could be uploaded quite regularly (I could maybe even show them how to FTP it).  Plus, of course, also put up a Search page in ASP that was linked to from the Web site on the cPanel server.

If you think this is a silly idea or not worth considering, I'm not offended and happy to give the other a go!

You know, re your question about the current world situation ... the Australian Government supports the US stand and have promised to send troops regardless. However, seems anyone I've talked to is against going to war.  Doesn't seem the solution. Personally, I think Bush Senior should of done it properly in the first place!  There are lots of rallies and many organisations lobbying against it here.  Public opinion is certainly divided as it is in the US.  Having said that, what's your opinion?

Thanks again for your time!
Later, Sanengel
0
 

Author Comment

by:Sanengel
ID: 8171455
Hey DialM4Monkey,

Yep, if the client moved to a windows/ASP server they would loose many of the features of the cPanel that they want ...

But, what I was actually contemplating was the idea of  "also" getting a windows/ASP server. This new ISP's Hosting fees are very reasonable ($125 Australian p.a. for the basic package whether cPanel or Windows).

So, I was thinking that if overall it helped things run more effeciently ....  $250 p.a. all total would be well worth it to the client. For that matter, they were spending over $550 pa for hosting. And funny thing is, although they were impressed with all that the cPanel had to offer, they weren't really comfortable with the fact that it was so cheap!

I guess I was kinda thinking that then the db wouldn't have to be converted all the time and could be uploaded quite regularly (I could maybe even show them how to FTP it).  Plus, of course, also put up a Search page in ASP that was linked to from the Web site on the cPanel server.

If you think this is a silly idea or not worth considering, I'm not offended and happy to give the other a go!

You know, re your question about the current world situation ... the Australian Government supports the US stand and have promised to send troops regardless. However, seems anyone I've talked to is against going to war.  Doesn't seem the solution. Personally, I think Bush Senior should of done it properly in the first place!  There are lots of rallies and many organisations lobbying against it here.  Public opinion is certainly divided as it is in the US.  Having said that, what's your opinion?

Thanks again for your time!
Later, Sanengel
0
 

Author Comment

by:Sanengel
ID: 8171457
Hey DialM4Monkey,

Yep, if the client moved to a windows/ASP server they would loose many of the features of the cPanel that they want ...

But, what I was actually contemplating was the idea of  "also" getting a windows/ASP server. This new ISP's Hosting fees are very reasonable ($125 Australian p.a. for the basic package whether cPanel or Windows).

So, I was thinking that if overall it helped things run more effeciently ....  $250 p.a. all total would be well worth it to the client. For that matter, they were spending over $550 pa for hosting. And funny thing is, although they were impressed with all that the cPanel had to offer, they weren't really comfortable with the fact that it was so cheap!

I guess I was kinda thinking that then the db wouldn't have to be converted all the time and could be uploaded quite regularly (I could maybe even show them how to FTP it).  Plus, of course, also put up a Search page in ASP that was linked to from the Web site on the cPanel server.

If you think this is a silly idea or not worth considering, I'm not offended and happy to give the other a go!

You know, re your question about the current world situation ... the Australian Government supports the US stand and have promised to send troops regardless. However, seems anyone I've talked to is against going to war.  Doesn't seem the solution. Personally, I think Bush Senior should of done it properly in the first place!  There are lots of rallies and many organisations lobbying against it here.  Public opinion is certainly divided as it is in the US.  Having said that, what's your opinion?

Thanks again for your time!
Later, Sanengel
0
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8177308
I dont think the database will have to be converted all the time.  If the Linux server understands the COM command correctly then we can read the data directly from the database after it has been FTP'd for the day or however often you want to do it, but we shouldn't have to convert it.  Thats what the previous example should test.

If the client gets both services would there be 2 different domains?

If the Linux server doesn't support the database in its native format then we have 1) store the data in some other format, like csv or tab delim or 2) go with the Windows server AND the Linux server right?

All-in-All if the Linux server DOES support the database in its native format then I'd say 50/50, its not a big deal on the programming side.  If, however, the Linux server DOESN'T support the database then the 2 server approach will save someone from having to convert the data into a format Linux will like every time you upload it.  I cant really see how having 2 servers would complicate things too much, except it may seem a little strange to an IT guy that may inherit the whole thing someday.

I think the first thing should be to test the Linux server and see if can hit the database in its native format.

0
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8177541
re US/IRAQ

first of all, its something I'm very concerned and passionate about, so if I go off the deep end or bore you with long msgs just tell me to can-it. BUT...

[Deep breath...]

In short my opinion is that I think Sadam needs to go, but I dont fool myself into thinking the oil has NOTHING to do with.

I think money is a big reason we're going there.  I think money is a big reason France DOESN'T want us in there.

The world wanted to pacify Hitler(Sadam) for a long time too, yet those who oppose the war say this is a war of agression by Mr. Bush (we call him shrub {little bush})

My biggest hope is that democracy does in Iraq what democracy is SUPPOSED to do in US

My biggest fear is that this will begin a movement of very destructive anti-americanism that could well polarize into a Judao-Cristian/Islamic holy war

I think people forget the fact that Sadam has been thwarting the UN sanctions for YEARS! 12 of them in fact.

Someone told m recently that Pancho Villa (Mexican Revolutionary) would wait until the Federales would come into a village and kill a few people before he would swoop in and "rescue" them, this approach would incite the townfolk into joining his cause.  So is it true that it is human nature to wait until we are backed into a corner before striking back?



we'll I'm done ranting...

;)


0
 

Author Comment

by:Sanengel
ID: 8185228
Hi there,

Sorry for the delay in responding ... another client's project took over entirely for a bit!  And I hope you don't mind if I deviate from the other topics for now and ask you another little question re ASP ...

This same client (a Web site I did not build but am maintaining that is ASP/Access ... actually my introduction to ASP!).  Anyway,  the client wants the word allowance for a particular field on the Results page to display more characters than it is set to currently.  

Can you tell me .... am I correct in assuming that the following code means the word count is set to "100" characters?  If so, can I just change the value here in the code to say 200 or 300?   Or does it have to be changed in the database itself?   Or both?

<% Response.Write (""&Left(rsevents.Fields.Item("memberlongdescription").Value,100)&""&dot&"<br><br>") %>

Not knowing Access etc, I didn't want to muck anything up!  

Thanks for any advice on this. hope to respond to your other notes shortly. And hope you are planning a nice weekend, Sanengel
0
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8195004
Sanegel -

Weekend was fine, how was yours?

The response.write line is displaying the first 100 chars (starting on the left) of the "memberlongdescription" field

I think your assupmtion is correct.  changing the code to 200 or 300 should display the first 200-300 chars in the field.  I think you will only have to change the database if you are unable to INPUT all the data you want to. i.e. the field can be set to a maximum of 255 chars before you have to convert it to a "MEMO" field (which holds an unlimited amount of data)
0
 

Author Comment

by:Sanengel
ID: 8198213
Hi there,

Good to hear you had a nice weekend ... mine was OK too, nothing exciting. Was hoping to get to the beach for a long run and play with the dog ... but it was a bit cooler and not as sunny as I'd hoped.

I did manage to watch a bit of news, which I must say I have pretty much avoided now since "Sept 11th".  The media make me crazy sometimes. I don't know about in the US now, but here they repeat over and over and over.  They are reporting the current situation sort of like a sporting event!

Anyway, don't worry about sending me long messages on the subject ... I like hearing what you have to say.  You can keep me abreast!  Course, I'm not sure we are allowed to use this list for personal, are we?  I'm happy for you to send to me direct on sandra@internode.on.net.

Thanks for your reply re the word allowance. So, if I go ahead and change to 300 in the code, it won't make the actual db die or anything!?!  I've got backups, but still worried I might lose data.

OK, I hope to get back to my initial query soon!  Other  things seem to have taken priority for the moment.

I didn't realize that you meant the database would not have to be converted all the time if the Linux server understands the COM command. That sounds very exciting!  

I really have to attend to some other work first, but I'll try and run that test as soon as I can. Then we can take it from there, huh?

Oh, you asked if the Linux server doesn't support the database in its native format then we have to 1) store the data in some other format, like csv or tab delim or 2) go with the Windows server AND the Linux server right?  

"Yes", if I understand everything .... those are our two choices.

You also asked if the client gets both services would there be two different domains?

"No" didn't plan on it, but hadn't given that much thought. Interesting .....

Well must get to it. Bye for now, Sanengel




0
 

Author Comment

by:Sanengel
ID: 8214951
Hi again,

I just tried running the snippet you provided above and I get this message:

Fatal error: Cannot instantiate non-existent class: com in /home/hannafor/public_html/testingdb.php on line 11

So, I guess that means the Linus will not support the db in its native format, right? Or could I have done something wrong?

Anyway, if that means it won't work, then I need to hurry and set up this Windows server and design a page in ASP so the Franhisees are able to search and print off individual
results, as well as search by date etc etc?  Just got a request this morning ... they are getting anxious!

Do you have time to get me started here? I've just upgraded to Dreamweaver MX and going to go check their tutorials.

Thanks heaps for helping me sort this out! Sandra
0
 

Author Comment

by:Sanengel
ID: 8216702
Hi again,

I just tried running the snippet you provided above and I get this message:

Fatal error: Cannot instantiate non-existent class: com in /home/hannafor/public_html/testingdb.php on line 11

So, I guess that means the Linus will not support the db in its native format, right? Or could I have done something wrong?

Anyway, if that means it won't work, then I need to hurry and set up this Windows server and design a page in ASP so the Franhisees are able to search and print off individual
results, as well as search by date etc etc?  Just got a request this morning ... they are getting anxious!

Do you have time to get me started here? I've just upgraded to Dreamweaver MX and going to go check their tutorials.

Thanks heaps for helping me sort this out! Sandra
0
 

Author Comment

by:Sanengel
ID: 8221754
Hi DialM4Monkey ,

I haven't heard from you in a while, hope everything is OK with you there.

Aside of now needing to go ahead with setting up the Windows server and figure out how to connect and search the Access db, the client is also requesting that an email notification be automatically sent to the Franchisee containing data of any new records posted.  

Now, this can only be possible if I get the client to enter the data online, correct?

So, that would mean also designing a page that adds data to the db, right?

Look forward to hearing from you, Sanengel
0
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8227404
It sounds like we ARE indeed going to need the windows server unless you want to convert the DB to a csv every time you upload.  I'm still not sure how 2 webservers are going to serve the same domain.  what I mean is I'm not sure how we will keep the linux server AND the windows server.  be sure to ask the ISP about that before you commit yourself. I think you are correct that in order for the server to know when new records are added the user would have to maintain data online.

Sorry I haven't responded in a while, dont get the wrong impression I still want to help, just a little busy.  let me know
0
 

Author Comment

by:Sanengel
ID: 8228142
Hi there,

Great to hear from you. I truly appreciate your help and do apologize if I am sounding pushy or anxious!  

Actually, I contacted the ISP yesterday, and they said they would also give my client a small Windows package for the ASP db for free ... but said we would need to get a domain name to search it .

I told them that was wonderful, but didn't expect it for free. Anyway, so today I was going to put in the order with them, which includes a domain name that I've already cleared with my client --being applicable to their Members (franchisees).

Now I guess we just need a search page in ASP that allows the franchisees to search for their various client's seed testing results. So they can print them out etc.

Then in due course, but not as urgent, my client would  like  new test results to be emailed to the respective Franchisee each time a new record is added to the db.

I told them to do this they would have to be willing to enter the data online. But now I am wondereing, wouldn't there be a function/script in Access that would do this for them. (Even if they weren't on the internet 24hrs, I'm thinking it would generate the email and put it in their outbox, then when they went on  line, hopefully each day,  any emails would be sent.)

Anyway, I'm very anxious to get going on this but do understand totally if you are flat out busy.

So,  look forward to hearing from you when you have the time.

Any more thoughts on "the war"?
0
 
LVL 2

Expert Comment

by:DialM4Monkey
ID: 8253395
Hey Sanengel,

Sorry so long in responding.  So we need to get the search page ready to go, correct?  can you show me the structure of the db?  better yet can you email me a copy?  You should delete any sensitive data if you do.  dummy data would be ok.  I have a cool little script that you are welcome to use that makes accessing the db easier.  go ahead and describe in detail how you want the search page to work.  If you want, you are welcome to email me at kellyroberts88@yahoo.com.  

re the War...

I heard yesterday that they rescued a 19 yr old female POW.  My heart trully goes out to her and all of the other POWs.  The Regime is brutal enough to their own women, I can't imagine how they treat the POWs.  I am worried that there will be more civilian shooting incidents like the one a few days ago.  Its got to be a tough call on the soldiers part... one day a taxi drives up to you and blows up, the next day a bus refuses to stop, so you shoot it up, but this time its full of women and children... what else do you do?  I wouldn't be suprised if the Regime somehow orchestrated it.  I still support the War.  I still support the Troops, I still distrust my governments motives.

Later...
0
 

Author Comment

by:Sanengel
ID: 8256531
Great to hear from you! I will email you a copy of the db privately.

I reallly thank you for helping me out .... I've been trying to learn a bit about ASP, a bit about Access, a bit about how to set up a data source/database on the server, a bit about the Windows server itself and ..... I must say....  my head is spinning a bit .  I've not gotten very far.

The client is getting pretty anxious to have this functioning, so I was starting to feel I'm letting them down.

I will email you now ... and shall I leave this question open to post the script you spoke of or just  select your code above as the answer and close this thread out?

Oh, and I agree with every word you said re the war.

Talk to you soon, Sanengel
0
 

Author Comment

by:Sanengel
ID: 8287473
More than helpful ... understanding, encouraging, ever so informative and generous with time ....  and very much an inspiration to want to learn more and more.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question