|
Thanks a lot!
I was born intelligent
Education ruined me!.
|
|
|
|
|
I have a website that is developed in PHP and uses MS-Access through ODBC. Is there an easy way to get this running on Linux/MySQL with minimal effort. I understand that I can port it to use mysql_* or ADODB libaries, I am just wondering if there is an easier way.
Also is there a way to generate a .SQL file from Access Database that can then be imported into MySQL (or phpMyAdmin).
Also if you know of a hosting company that provides cheap Windows hosting packages, please let me know. My requirements are:
Email 1-5
Diskspace 25MB or above
PHP
MS-ACCESS
Thanks,
Victor
phpWebNotes is a page annotation system modelled after php.net.
http://webnotes.sourceforge.net/demo.php[^]
|
|
|
|
|
I have a web based form to collect the data from the user. I have completed all except few details from the user. I mean the hidden details. How do I take the ip-address related stuffs. I have seen some site-logs that displays the people logged in, their origin, the browser, etc, etc. How do I collect them. How can I know the person's origin(Country/continent)???????
I started with nothing,
And I still have lots of it left with me.
|
|
|
|
|
Play with this a bit to see if it helps:
<%
For Each Key in Request.ServerVariables
Response.Write Key & " "
If Request.ServerVariables(Key) = "" Then
Response.Write " <BR>"
Else
Response.Write Request.ServerVariables(Key) & "<BR>"
End If
Next
%>
It should provide a list of all the goodies that each .asp page request from a client generates, according to the text I paraphrased it from. Some of the info you want will be found in REMOTE_ADDR, REMOTE_HOST, REMOTE_USER, ETC. It should also return values with names such as HTTP_ACCEPT (a list of MIME types the client can handle), HTTP_ACCEPT_LANGUAGES (a list of human languages supported), HTTP_USER_AGENT (the browser version, OS, and type of browser), and HTTP_CONNECTION (the type of conection). Some of this is likely to be handy.
Mind you, it's about 2:00 AM, I haven't slept in two days, and I'm definitely not alert enough to try it for you, but it's a start.
"How many times do I have to flush before you go away?" - Megan Forbes, on Management (12/5/2002)
|
|
|
|
|
Roger Wright wrote:
but it's a start
This info is enough for me....
Where does the country info come from???
I started with nothing,
And I still have lots of it left with me.
|
|
|
|
|
That information isn't in the headers, or important to the concept of a World Wide Web. You may be able to make some reasonable guesses from the domain name and language information, but generally I doubt that; the idea of country codes hasn't caught on much. You could do better by doing a WHOIS search on the remote host domain, then scanning the data for an admin address, but in most cases that won't help much. Most ISPs own large IP address blocks, so the info would be misleading.
A possibilty, though, is to write a script to return the locale id (LCID) of the client computer and return it to the server, but I haven't a clue how to do that. The Session Object in ASP contains a Session.LCID property, but it refers to the content to be served by the web server, not the client.
Perhaps it would be simpler to ask?
"How many times do I have to flush before you go away?" - Megan Forbes, on Management (12/5/2002)
|
|
|
|
|
Thanks.,...
I started with nothing,
And I still have lots of it left with me.
|
|
|
|
|
VBScript Roger, and I thought you were learning too? 
Please leave your keys at the front desk on your way out the door... 
"Desktop Bob told me to start fires" - thematt
|
|
|
|
|
Aw.. give a guy a break, David! Every book on ASP or ADO, every article I've found on MSDN, uses VBScript exclusively. I've got jobs that need to get out the door, not wait on me to figure out, without any guidance or references, how to make Javascript work. Your forum is the only useful Javascript code I've got to study above the "Hello World! Aren't you feeling foolish about buying this worthless book?" level.
You're welcome to the keys, though. I've got a full set of lockpicks (working for Ace Hardware presented some unique buying opportunities) and know how to use them.
"How many times do I have to flush before you go away?" - Megan Forbes, on Management (12/5/2002)
|
|
|
|
|
I started with nothing,
And I still have lots of it left with me.
|
|
|
|
|
You never mentioned whether you got your app working the way you want it to. How's it going?
"How many times do I have to flush before you go away?" - Megan Forbes, on Management (12/5/2002)
|
|
|
|
|
Its already working... but for working it "Better" I needed u guys' help. I will try to get that
I started with nothing,
And I still have lots of it left with me.
|
|
|
|
|
I am looking for a slider control which works on Netscape 4+. I have found many which work on IE 4+ but finding one that works with Netscape has been difficult.
Can anyone suggest a good slider control which will work with Netscape, IE and Mozilla?
Thanks in advance.
Matt Gullett
|
|
|
|
|
I guess you could make something in shockwave, then it would work on any browser that supports shockwave (which is most modern ones)
--
Help me! I'm turning into a grapefruit!
|
|
|
|
|
I do the following:
strBacsLocation = Request.ServerVariables("APPL_PHYSICAL_PATH") & "dir1\dir2\"
then append the file name (different each time as the GUID from SQL is appended to the end of the filename) as such:
strDate = day(date) & "/" & month(date) & "/" & year(date)
rRunGUID = rstBacs.Fields("RunGUID") 'get the GUID from SQL stored procedure recordset
set FSO = server.CreateObject("scripting.fileSystemObject")
path = strBacsLocation & day(date) & month(date) & year(date) & "-" & rRunGUID & ".txt"
This works great, each day (or run for testing) we get a completely unique text file placed exactly where we want it. My problem is this - it is the absolute path, not the web path. I want to be able to put a hyperlink to the file so the FD can click and see the text file in IE immediately.
So how do I get the "web" path as it were?
Thanks 
I knew it would end badly when I first met Chris in a Canberra alleyway and he said 'try some - it won't hurt you'..... - Christian Graus on Code Project outages
Damned nice for remote servers where using Enterprise Manager is like wadding through treacle while covered in velcro, upside down -Paul Watson on SQL Server Query Analyser
|
|
|
|
|
can't you just remove the front part of the path?
[edit]in .NET there is a PhysicalPath method on the Request object[/edit]
Technically speaking the dictionary would define Visual Basic users as programmers.
But here again, a very generalized, liberal definition is being employed and it's wrong
- just plain wrong - Tom Archer 5/12/02
|
|
|
|
|
Shaun Wilde wrote:
can't you just remove the front part of the path?
hmmm... sounds reasonable - I'll give it a try, thanks
Shaun Wilde wrote:
in .NET there is a PhysicalPath method on the Request object
We are only upgrading to .Net in February 
I knew it would end badly when I first met Chris in a Canberra alleyway and he said 'try some - it won't hurt you'..... - Christian Graus on Code Project outages
Damned nice for remote servers where using Enterprise Manager is like wadding through treacle while covered in velcro, upside down -Paul Watson on SQL Server Query Analyser
|
|
|
|
|
ignore the edit - too much coffee
Technically speaking the dictionary would define Visual Basic users as programmers.
But here again, a very generalized, liberal definition is being employed and it's wrong
- just plain wrong - Tom Archer 5/12/02
|
|
|
|
|
Why not construct the web path, and then use Server.MapPath to get the absolute path:
strBacsWebPath = "/dir1/dir2/"
strBacsWebPath = strBacsWebPath & Day(Date) & Month(Date) & Year(Date)
strBacsWebPath = strBacsWebPath & "-" & rstBacs.Fields("RunGUID").Value
strBacsWebPath = strBacsWebPath & ".txt"
strBacsAbsolutePath = Server.MapPath(strBacsWebPath)
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
Sounds like another good plan - thanks
I knew it would end badly when I first met Chris in a Canberra alleyway and he said 'try some - it won't hurt you'..... - Christian Graus on Code Project outages
Damned nice for remote servers where using Enterprise Manager is like wadding through treacle while covered in velcro, upside down -Paul Watson on SQL Server Query Analyser
|
|
|
|
|
Hi,
I have an Access database on my website that contains emails and birthdates of my clients. It also has a field for whether or not they want to be emailed my newsletter. I want to be able to automatically run a script daily from my site that will check the database for birthdates and send an email to the address in the table on their birthday. Has anyone ever done this before? 
Thanks so much...;)
Melanie
|
|
|
|
|
mgarvin wrote:
Has anyone ever done this before?
Why not you give a try on it???
I started with nothing,
And I still have lots of it left with me.
|
|
|
|
|
mgarvin wrote:
Has anyone ever done this before?
Yes, most websites find the need to do this.
There are many ways of doing it, none that I know of that use ASP though. Remember an ASP page is only ever activated by an external source. e.g. an IIS request. So it cannot sit there checking date and time every x number of hours/minutes.
Here are three common ways to achieve what you want.
1. Create a Windows Service app. Have it sitting on the server checking the dB and date/time. When it matches what it needs to then it can send off the email.
2. Use the Task Scheduler built into Windows 2000/XP Server to run a Windows app which does the same as the Windows Service app.
3. Create a Job in SQL Server with a recurring date/time. You can send emails from within SQL.
The details of doing the above three can easily be found via Google or even here on CP.
Paul Watson
Bluegrass
Cape Town, South Africa
Christopher Duncan wrote:
Which explains why when Santa asked, "And what do you want for Christmas, little boy?" I said, "A life." (Accesories sold separately)
|
|
|
|
|
Not sure where the best place to ask this is.
I am just trying to experiment with SSL connections and want to get an instance of MS's Certificate server up on a home network. I have 5 machines set up with one being a W2K server and have IIS and the Cert Server installed but not setup. Can any one direct me to a source for some quick and dirty instructions for doing the configuration.
The service manager says it is running but I can not get to it. Obviously I need to set IIS's configuration so the call to the cert address get routed correctly.
I am not really trying to learn how to do a professional setup or administration (not enough hours in the day for me.) Just need the basics running so I can have some programming fun.
"I will find a new sig someday."
|
|
|
|
|
This is just for the record.
I had cleaned up all of the default documents other than index.html for IIS. The CertSrv uses default.asp. Egad  
"I will find a new sig someday."
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
