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
