I linked the mysql tables into my access database and did a cut and paste of the access tables into the mysql tables. This was an intranet setup though. Rolf Hopkins wrote: > ----- Original Message ----- > From: "Joe and Nancy M" <[EMAIL PROTECTED]> > To: "Rolf Hopkins" <[EMAIL PROTECTED]> > Sent: Tuesday, February 20, 2001 21:04 > Subject: Re: need mysql sample to accomplish existing asp function > > > Rolf, > > > > Sorry I worded that email in a confusing manner. > > You most certainly were! Now I get your meaning. > > O | O > \____/ > > > > > My ISP told me they supported asp, so I had a friend of mine set up the > asp > > code for me and he tested it on his server. When I put the code in my > > pages, it did not work. I called my ISP back and found out the first > person > > was wrong. They run Unix and DO NOT support asp. > > They need to fire the first person you talked to or was he/she just a > secretary and if so, why is he/she answering tech questions? To not even > know what your own machine is set up with/capable of, geesh! > > I'm not surprised that many ISPs don't support asp. Someone correct me if > I'm wrong, but Chillisoft, the only program I know of that let's you run asp > on unix, costs something like US$1000. > > > > > So, yes... I have to use mysql. I have no familiarity with mysql and was > > hoping someone could give me a sample chunk of code that makes the > > connection, queries the file and displays the results on the page. > > Something similar to the asp code I showed in my message. > > Well now, that depends on what you want to use. You can use java, php, or > perl and there are others but make sure your ISP supports the language you > choose. I recommend php as it is the easiest of the three. Their web site > is www.php.net and www.devshed.com have plenty of examples. And don't > worry, if you were able to set up a connection in asp, I think you'll find > php a little easier. That's connection only. > > Have you programmed in C before? If not, you'll get your first taste of C > and you should read the php manual carefully. For example, if statements > are not as easy as you think and you should take note of the double equal > sign. A common error for newbies. > > > Sorry for the confusion! > > Joe. > > > > ----- Original Message ----- > > From: "Rolf Hopkins" <[EMAIL PROTECTED]> > > To: "Joe and Nancy" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Tuesday, February 20, 2001 12:23 AM > > Subject: Re: need mysql sample to accomplish existing asp function > > > > > > > I'm confused. You say you are in a time crunch to get mysql working on > > your > > > site but you have no mysql connection/code. You say you coded and > tested > > on > > > another site and it works. If I'm right, that other site had the > Windoze > > OS > > > as their web site which of course it work fine... > > > > > > ... unlesss ... > > > > > > does anyone know if a Microsoft Excel ODBC Driver exists for unix > systems? > > > Hahahahaha.... > > > > > > I don't see how Microsoft would even dream of creating such a thing. > Your > > > new ISP is probably unix just like the majority of web servers on this > > > planet and doesn't know about Microsoft Excel ODBC Drivers. > > > > > > My suggestion is that you start looking at MySQL if that's what you are > > > going to do or ask your ISP if they have Windoze servers and move across > > to > > > that. They will, of course, need the Microsoft Excel ODBC Drivers. > > > > > > Cheers, > > > > > > Rolf > > > > > > Your mouse has moved. > > > > > > Windows NT must be restarted for the change to take effect. > > > > > > Reboot now? [OK] > > > > > > > > > ----- Original Message ----- > > > From: "Joe and Nancy" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Tuesday, February 20, 2001 12:15 > > > Subject: need mysql sample to accomplish existing asp function > > > > > > > > > > I am in a time crunch to get mysql working on my site. I export > > inventory > > > > records out of my Peachtree software into Excel and planned to use > that > > > .xls > > > > table to show product pricing and availability on my web pages. Below > > is > > > > sample asp code that works. My ISP had told me they support asp, but > > > after > > > > coding and testing (at another site), I found that my ISP really > doesn't > > > > support asp. Can anyone provide a sample chunk of mysql code that > would > > > do > > > > what this asp code does... > > > > > > > > -------------- > > > > > > > > At the top of the page, setting the connection to the .xls (would be > > > > slightly different for a database connection): > > > > > > > > <%@ Language=VBScript %> > > > > <%Option Explicit%> > > > > <% > > > > 'Declare Variables > > > > Dim cnnExcel, rsProduct, strSQL > > > > 'Connection Object > > > > set cnnExcel = server.createobject("ADODB.Connection") > > > > cnnExcel.Open "DRIVER={Microsoft Excel Driver (*.xls)};DBQ=" & > > > > server.MapPath("../catalog.xls") & ";" > > > > 'RecordObject > > > > set rsProduct = server.CreateObject("ADODB.recordset") > > > > %> > > > > > > > > Next to each product is this code, it shows the price and qty from the > > > file > > > > and an image with a hyperlink if qty > 0: > > > > > > > > <% > > > > 'Code for checking inventory > > > > 'SQL > > > > strSQl = "SELECT * FROM [Sheet1$] WHERE ((([Sheet1$].[Product > > > > Code])='blizzard'))" > > > > 'Open Recordset > > > > rsProduct.Open strSQl, cnnExcel > > > > if not rsProduct.EOF then > > > > Response.Write "Price: $" & rsProduct.Fields("Price").Value & > > "<br><br>" > > > > Response.Write "Quantity on Hand: " & rsProduct.Fields("Qty in > > > > Stock").Value & "<br><br>" > > > > if rsProduct.Fields("Qty in Stock").Value > 0 then > > > > Response.Write "<a href=""url here""><img > > > src=""images/button.gif""></a>" > > > > end if > > > > end if > > > > %> > > > > > > > > The bottom of the page closes the connection: > > > > > > > > <% > > > > 'Close Objects > > > > rsProduct.Close > > > > Set rsProduct = Nothing > > > > cnnExcel.Close > > > > Set cnnExcel = Nothing > > > > %> > > > > > > > > ----------------------------- > > > > > > > > Thanks in advance if anyone can give me direction on how to accomplish > > > this! > > > > > > > > Joe. > > > > > > > > > > > > --------------------------------------------------------------------- > > > > Before posting, please check: > > > > http://www.mysql.com/manual.php (the manual) > > > > http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > > <[EMAIL PROTECTED]> > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php