----- 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
