Any Ideas How To Run Macro In Microsoft Publisher Through PHP COM ?

SQL Error: [Microsoft][ODBC Microsoft Access Driver] Too Few Parameters
I'm trying to execute the following SQL statement and get the following error.

SELECT DomainNames.DomainName FROM DomainNames WHERE DomainNames.DomainName Like "*ab*" ORDER BY DomainNames.DomainName

SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect

I'm running PHP4, Apache 1.3.12 (Win32) and connecting to an Access database on a Win2K box.

---

Odbc_exec(): SQL Error: [Microsoft][ODBC Microsoft Access Driver]
i am trying to write to the database through odbc. i get the following error:

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query., SQL state S1000 in SQLExecDirect in c:inetpubwwwroot514VIP_SurveyProcess.php on line 41

my directory has read/write permissions why am i getting this? here is the code as an example:
...
$x = 10;
$querySet = "UPDATE Survey SET $rdoOption = $x";
odbc_exec($objConn, $querySet);
...

---

Macro?
I want to perform the same test (if statement)on many variables.. Let's call them $count1, $count2, . Is there a way to do this like a macro? Instead of having to type the same statement over and over, i figure there is a way to do this with a macro or some kind of loop.

---

Macro In PHP ?
I am curious if there is a solution for the following in PHP4:
I often echo something to my browser during tests. I often forget to add a
<BR> to the end of the echo command.
Is it possible to use something like a mcro in C++ to have a command I can
use like echo but which automatically adds the <br> ?
Or is there a command that does that for me ?
Alternatively I could write a function of course, but then brackets come in
to play as well.

---

Fread - Any Ideas?
I have a socket open (opened with fsockopen()) and I'm sending pop3 requests over it. When I use fread() to get the response of the pop server, there's the possibility that the response can be of length anywhere between 1 character and several million (obvious reasons).

Does anyone know if there's a way to read the entire incoming data when you don't know the length of it, without putting in some rediculously large number into fread's length parameter?

---

Ideas ..with Webpage
Hello I didn't do any web page development since university ,I wanted
to create a web page for the fun of it ,an I was surprised of how easy
it is to use frontpage and dramweaver to do basic stuff ,but I wanted
to do something that I am sure it can be done but I don't really know
the way .
The webpage is not something original and it has been done before .
Xe.com is a currency converter from a currency to another currency I
have the following questions :

1) Wanted to auto detect the users country and accordingly set the
starting currency (from this currency) to the currency that his country
is using.
And also change the language to the user's language ...

2)lets say that I have users from two countries Germany and Hungary I
can create two starting web pages one with Hungarian and one with
German ..but lets say I have users from 30 different countries is not
very convenient to have to create a web page for each language there
must be a way that someone can i have a webpage that takes textiles or
something with the language strings and just displays them.

3) Lets say that the language is wrong and the user is using a computer
of the Spanish person and the user is Japanese I want to give them the
option to change the language
at any time ..do they have to install another language e.g Japanese in
this case? or only the encoding has to be changed .?

4)I wanted to give the user the option to select the currency in a
better way than dropdown box ,or a list box .. like a menu somehow but
I can't come with anything ...I don't know what guys can you
suggest I guess the list box is the obvious especially if there are
so many currencies but I would like something nicer... for example to
display the currency image at the side ..not sure..

5) If I create user login for example and I have different users that
they pay for the services how can I restrict certain currency converter
for certain users e.g. we have two users and the one user didn't pay
subscribed for the free service (he can convert Euro to dollars, visa
versa, pounds to dollars visa versa, pounds to Euro visa versa), the
user that paid can convert any currency ..

6) How can I restrict users from copying the website (using offline
explorer for example).

I was wondering what tools do I need to use to create the
website(recommended reading books?/online tutorials ),how will I be
creating the functionality that I want and how will I be resolving
every problem listed ?

---

Anyone Got Any Ideas On The Best Webstat Packages Available
Im trying to get a good solution to monitor webstats, pages including visitors and referrers.

---

Mysql_num_rows .... Error??? Any Ideas?
Does anyone have a good reason why I'm getting this error.
I'm clueless on this one...

I'm getting the error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource.

---

Aggregation Class Ideas?
I have many classes that use database connections to fetch data and manipulate on it. I also have database abstraction class that is handling all the database queries and so forth. Usually all my classes take instantiated database object as the first parameter to constructor so they know what database to use:...

---

Text To MySQL Problem Need Ideas
I know how to upload text files and such my problem is that I may have many many text files so any editing of the files is out of the question. The files are not delimited, well so far I use
and it works but with help of some editing.

---

Colance, Connecting Ideas With Professionals. J5j
Webmasters: Colance specialise in connecting your ideas with Freelance Professionals to produce your project.
Programmers: Providing your Service is made easy through Colance. It is free to sign up with no monthly costs.













UMwxniywdsCdYae

---

Any Ideas How To Read A Url That's Changed By The Server?
I apologize, but I posted this in the php general forum earlier and
realized that this is the more appropriate forum. Hopefully there's a
coder here who has done this in the past.

I've got code that uses CURL to go a web page to read the data.

When I type in www.website.com, the server automatically adds a
session variable to the url. I need to be able to read that session
variable. Then I will use that session variable to input into a new
CURL session.

Any ideas how I can do this?

If I use code like this:

// find out the domain:
$domain = $_SERVER['HTTP_HOST'];
// find out the path to the current file:
$path = $_SERVER['SCRIPT_NAME'];

It gives me the code for where my script is sitting on my server
rather than the values for the web site that I'm trying to read.

Any ideas?

---

Ideas For French/english Sites, Using PHP?
I run a small site, I used it to learn html, and now PHP, next MySQL! I live in Quebec Canada and I would like to translate my site into french. I think I can get many more hits if I let the people around here take a look at my site and understand it!

I wonder if I could use a smarter way to do this using PHP or even MySQL. Instead of having twice the html/php pages. I don't have any ideas with my limited knowlage of programming. Maybe using variables in the URL like mydomain.com/index.php?language=french&file_id=23 or something???

Well maybe it is more trouble than anything else and I shouldn't even think about it? Right now I'm just planning on making twice the pages and have a french/english page as my index for people to choose.

But if anyone has any ingenious ideas let me know! I like figureing things out for myself, but if you would point me in the right direction.

---

Any Ideas For Sending Out A Basic Newsletter
I want to send out a basic newsletter from my MySql database of contacts.

Does anyone know a nice and simple bit of PHP that allows me to do this?

---

Any Ideas On Invalidating A Session From Another Process?
I have a slight problem with sessions. I use a session var to store a
user's details and also a set of permissions to various parts of my
application. This involves several SQL queries which is why I do it once
and cache the result in a session var.

My problem occurs when I change a user's permissions. At this point I
need to invalidate that user's session to reload their new permissions.

I don't think it's possible to do it directly is it? I'm thinking at the
moment of a timestamp in the user record which requires an SQL query
every page.

---

Looking For Recent Visitor Code Examples/ideas
I am working on updating my content management page and wanted to overhaul my "recent visitor" code. The code that tracks who has been and is still on my pages.

I have not been able to find some examples I saw here a few months ago and was wondering if anyone could point me to some examples.

The more versatile the better.

---

Data Transfer Problem - Ideas/solutions
I have an interesting problem. I have a (LARGE) set of historical data
that I want to keep on a central server, as several separate files. I
want a client process to be able to request the data in a specific file
by specifying the file name, start date/time and end date/time.

The files are in binary format, to conserve space on the server (as well
as to increase processing time). The data in each file can be quite
large, covering several years of data. New data will be appended to
these files each day, by a (PHP) script. The server machine is likely to
be a Unix machine, whereas my clients will be running on windows
machines. My clients program is written in C++.

My main problems/questions are as follows:

1). Transfer method issue:
What is the best (i.e. most efficient and fast way) to transfer data
from the server to clients ?. I think SOAP is likely to be too slow,
because of the sheer size of the data

2). Cross platform issue:
How can I insure that that the (binary?) data sent from the Unix server
can be correctly interpreted at the client side?

2). Security issue:
How can I prevent clients from directly accessing the files (to prevent
malicious or accidental corruption of the data files.?

---

Ideas To Create User Personalize Page Without Login.
Hi,I am new with PHP, I am a new junior internet programmer. My boss asked me to do a personalize page for his search engine. Do any one willing to give some ideas of how to create a personalize page without login by user(only read the user cookies and mysql)

---

PHP Search Engine Code? (Rather Verbose Php Link) Any Ideas?
I've totally hit a brick wall and I've checked the numerous (some
helpful) tutorials in making a php link search engine friendly but the
following link:

<font face="Tahoma" size="2">
<a
href='ps2reviewsdisplay.php?page=ps2/ps2acecombatsquadronleader&type=htm&title=-
Ace Combat Squadron Leader Review - www.impulsegamer.com Australia'>
<span style="text-decoration: none">Ace Combat: Squadron Leader<br>
</span></a></font>

I just don't know how on earth to make it search engine friendly?

---

PHP On Microsoft-IIS/6.0
Is it possible to make IIS parse .html files the same way as Apache does
with AddType application/x-httpd-php .html in .htaccess?

---

Microsoft SQL Connection
I am looking to have a php page that will have a required include of a
config file with the MS SQL connection creation. I want to have a form
that saves into a MS SQL database. Could call out to a stored
procedure or have inline code in the php page.

Anyone have examples or generic sample code I can use?

---

PHP With Microsoft Sharepoint ?
I would like to ask if I can synchronize Sharepoint Services with my PHP
website?

Hint: I think it can be done by XML as a bridge.. but I am not sure and
wanna be sure.

---

PHP And Microsoft Access
Is it possible to use php to interface with an ms access database?

Our current database (customers, suppliers etc) is in ms access format and we need to run msaccess. I dont feel like converting the whole database over to mysql and we still need the original system, the idea will be that the staff can access the database on the road thru a webpage.

---

PHP And Microsoft Word
I have users who can sent a Word document as an attachment to an email
from a Microsoft-rich environment. I would like to be able to
"capture" that attachment as a blob and deposit it into a mysql
database. I am not sure how to do the capture.

---

PHP To Microsoft Outlook
Is it possible to send meeting notifications to microsoft outlook through php? I guess it would be sort of an e-mail sent to an individual telling them they have been invited to attend an event and the event info is automatically added to thier outlook calender or something?

---

Exporting To Microsoft Access
I have a PHP website with a mySQL database and a client wants to be able to see the database on his computer using Microsoft Access.

I would like to be able to make a special backdoor section for him, where he enters his username and password and is given a link which will make take a snapshot of the mySQL database and convert it to a Microsoft Access database which he can download to his computer.

Is this possible?

Since he isn't very computer savvy I need a way as user friendly as possible to let him download the database and view on his local computer.

---

Microsoft Exchange Server
Do any of you know a free PHP script that does the same stuff as Microsoft
Exchange Server?

---

Microsoft SAPI Problem With PHP
As I've found tons of VB and C# sample codes, I was trying to transform

it into PHP code, using the COM objects. My aim is to create a simple
html, that creates a wav from a text. Here's what I've tried -the php
script part-:

$Voice = new COM("SAPI.SpVoice");//works
//com_load_typelib("SAPI.SpVoice"); //This doesn't help...
$Voice->Speak("Hello!"); //works

$FileStream = new COM("SAPI.SpFileStream"); //works - I mean no error
$FileMode = SpeechStreamFileMode.SSFMCreateForWrite;// = 3 //works -
no error
$FileStream->Open("c:a.wav", 3, false); //works - no error
$Voice->AllowAudioOutputFormatChangesOnNextSet = false; //works - no
error
$Voice->AudioOutputStream = $FileStream; //HERE'S THE PROBLEM

$Voice->Speak("Hello world",1);
$FileStream->Close();

Here's the error I get for that line:
Uncaught exception 'com_exception' with message 'Error [0x80020003]
Member not found

---

PHP Wrapper For Microsoft SAPI
I can not figure out the reason why this does not go past step 2, it will not go to 2a. Code:

---

Microsoft Access -> PhpMyAdmin
Alright, so what’s going on is that I have coded an entire website with in mind to have an Access Database. So everything works great...

But now I am faced with the problem that I have to have my webpage work with phpMyAdmin, which works completely differently in running my sql statements and everything, ie: ->EOF, select statement, etc...

Is there a way for me to have a smooth transition for my code to work with phpMyAdmin instead of Access at the moment, because recoding all of this means an enormous amount of work with not much free time left on my hands. Code:

---

Microsoft Word Formatter
Anyone know of some sort of php script that can read and format Microsoft word documents?

---

PHP / Microsoft SQL V7/2000 - Page Results
Anyone know a simple way to page results of a SQL Select using Microsoft SQL ? I don't believe they have anything as handy as MySQL LIMIT.

---

Parse Error For Microsoft.XMLHTTP
I want the following ASP code to be rewritten in PHP:

<%
Set xml = Server.CreateObject("Microsoft.XMLHTTP")
xml.Open "GET", "http://www.mydomain.com", False
xml.Send
Response.Write(xml.responseText)
%>

I tried myself with ASP2PHP conversion tool. The following code was generated. But does not work. I get a parse error. Please help!

<?PHP
$xml->Open "GET" "http://www.mydomain.com" $False;
$xml->Send;
echo $xml->responseText;
?>

---

How To Embed Microsoft Word In A Page Using Php
how to embed or open microsoft word file in a page using php script

---

Microsoft Access Dropdown List
l am building a new site using PHP which has a lot of pages pulling from an Access Database. I would like to have a dropdown list that pulls exhibitions from the database and then when the user selects one it shows the rest of the details from DB just below the dropdown list, hope that makes sense. Code:

---

Reading Microsoft Office Documents?
I need to be able to upload a Microsoft office document and then show the contents to the visitor, in addition i need to be able to  write documents on the fly.

Is there a way of doing this, or will i have to spend days researching and programming my own classes to handle it?

---

PHP Will Not Read More Than 4096 From My Microsoft Sql Text Field.
I have a textarea that is saving to a mssql text (very large) field. The insert, update is working fine. However, when php reads the data using mssql_result function, I'm getting limited to 4096 characters read by php. I know that there are at least 6000 characters and I can see them using microsoft's query analyzer. This is not a magic quotes, single quote, quote, html entity or anthing like that. PHP will not read more than 4096 from my microsoft sql text field. Any ideas how I can get php to read more?

---

Insert Into Microsoft Access Table Using ODBC
The following lines of code don't return an error but they also do not insert the row into the database:

$SQLText="Insert into member (MailingID, MemberID, [File As], EMail, LetterID, AudienceID, DateSent, Sent) Select $MailingCode, $row[0], '".$row[5]."', '".$row[6]."', $LIDToInsert, $AIDToInsert, '".$DateSent."', 1;";

print '<br>'.$SQLText;

$rs_upd=odbc_exec($link, $SQLText);

if (!$rs_upd) die("Couldn't update database");

I've tested the resulting $SQLText string in Access directly and it works find there so this must be a PHP or ODBC issue.

---

Microsoft JET Database Engine Error '80040e10'
I am new to ASP, I am trying to create a page using ASP that will read from a database and write to my page, but I get this error every time: Microsoft JET Database Engine error ?e10' No value given for one or more required parameters.

---

Microsoft And Zend Announce Collaboration To Enhance PHP On IIS
Microsoft's Product Unit Manager for Internet Information Services
(IIS), announced a new collaboration with Zend to improve
performance and stability of PHP on Windows.
This isn't just vaporware, either. During Andi Gutmans' keynote
(Andi is one of the creators of PHP and co-founder of Zend), Bill
announced the availability of a technical preview release of FastCGI
for IIS and demoed it for the audience as well.
FastCGI is a new component for Microsoft's Web server platform that
is available for download & evaluation today. It works IIS 6.0 in
Windows 2003 Server and IIS 5.1 in Windows XP. Even cooler, it also
works with the brand new IIS 7.0 making its debut with Windows Vista
and, later, as part of Windows Server code-named "Longhorn."
This announcement continues to solidfy IIS as the premiere Web
application server whether you are developing sites with ASP.NET or
any other server framework. Moreover, regardless of the programming
language or framework they choose, developers building sites of any
size can leverage the full capabilities of the Microsoft platform
with enterprise-class security, speed and stability.

---

Inserting A Date Into A Microsoft Access 97 Database
I was wondering if anyone could help me insert a short date into microsoft access 97 using php? i can insert text no problem but i can't seem to be able to insert a date properly. i have been using

//$date = "#" . "$sqlmonth" . "1" . "$cboyear" . "#";

$strSQL = "INSERT INTO tblSupport (tDate) VALUES ($date)";
$result = odbc_exec($connect, $strSQL);

Note: i can insert a date if i hard code it like putting in #01

---

Warning: SQL Error: [Microsoft][ODBC Driver Manager]
Cannot get an ODBC (or MSSQL) connection to MS Sql Server 7. Using a system datasource and it connects fine, but PHP does not like it. I've had no problem with NT4 but Win2K is another story...

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:inetpubwwwrootindex.php on line 8

---

Can I Convert MySQL Db Records Into Microsoft Word Documents?
i found the solution to export
file from mysql db into *.csv. but is there anyway to convert the
contents into *.doc and save in my webserver and providing a link for
the end users to download the word file?

FYI, the database records are obtained by end users submitting the
forms themselve and i saved it in my db...

---

PHP Equivalent For Server.CreateObject("Microsoft.XMLHTTP") In ASP
I'm new to PHP, so I'm trying to figure out how to do things that I used to do in ASP.

One of those things is getting data from another web page, server-side.

In ASP, I'd do this:

Set objXML = Server.CreateObject("Microsoft.XMLHTTP")
objXML.open "GET", strURL, False
objXML.send()

I could then use regexp to pull out data from objXML.responseText.

How can I do the same thing in PHP?

---