Hummm... (Note to self: NOT a very friendly forum here.)
PS: I forgive you - Frederico! But we just can't go on like this. I'm leaving you and won't be back.
Bye! :)
Dearest Frederico...
I appreciate your deepest concern for my experimental acedemic enlightenment.
However, I would like to know the answer to my question PRIOR to messing with code that someone else wrote. Hense, the question.
Your unsolicited response has not only served to leave my question...
Let's say $myData = "Let's party!"
If code in a PHP form includes addslashes($myData) and $myData is inserted into a field of a mySql table...
What ends up in the table?
"Let's party!"? OR "Let/'s party!" OR ???
I'm looking for a website analyzer with a mysql back end that will allow me to run a query against the hits.
Let's say - how many hits on the whole site (lots of pages) since July 1, 2003
and then display that on the front page of our website.
Anyone know of anything like that, or something...
I have a PHP form that gathers user input which I store in a mySql table.
A textbox gathers request data and places it in the var $request.
I run the following query to store the entered data in the table:
//Insert variables into table of previously selected DB.
$query = mysql_query("INSERT...
(Using D5 and Paradox tables.)
I have a group of cascading tables displaying the current record of table 1 in Edits, related records from Table 2 in a grid, etc...
In my code I am doing a while loop through Table1 and doing queries within the loop.
As the code runs, the user can see the Table1...
When Paradox came out it had a "Query by Example" engine built in, and only provided the most basic SQL capibilities. Evidently no IIF, no IF no CASE etc...
(FYI: Booleans = True or False in Paradox.)
I really appreciate your assistance.
But since I couldn't gather what I needed using SQL I...
I've never learned much SQL and I'm having some difficulty gathering the data I need for an important report.
The problem seems to be that I have two sum()s on the same field based on if another field is True or false.
I can get one value but not the other in one query.
Plus if I get the second...
Hey guys,
Thank for your help and comments.
Unfortunately, I'm programming in Delphi using Paradox tables. (Sorry I didn't say so before.
Evidently, It took the "Between" code but doesn't seem to like the IIF code. (Error: Capibility not supported!)
I know that ties one hand behind your back...
Golom,
Thank you for your response.
Actually the two sums that I need to get are both Sum(Amount).
One where TaxDed = True and the other where TaxDed = False.
Select C.CustID, C.CustName, C.AddrFields,
SUM(F.Amount) As DeductableAmount
// SUM(F.TaxDed) As NonDeductableAmount...
I have a Customer table, a Donations table and a FundSplit table. Relationship: (Customer <->> Donations <->> FundSplit)
Customer Fields: CustID, Name, ... (address fields)
Donations Fields: CustID, DonationID, Date, ...
FundSplit Fields: DonationID, Amount, TaxDed, ...
What I am after is a...
In my D5 Application - When I click on a button I can start an instance of MS Word, open a document populate it with text, save it, print it to the default printer and close it..
But, how might I allow the user to access the MSWord FilePrint Dialog to select the printer to print to prior to it...
In my PHP code:
I have a var:
$server = 'http://192.168.1.3';
How I do I use that var in the following JavaScript so that I don't have to hard code the server ip in it?
-----------------snip----------------------------
<script LANGUAGE="JavaScript"><!--
function OpnWindSize(w,h) {...
Zathras,
That did the trick!
I am a minister (not a programmer) programming a significantly large application by myself because I can't seem to find any skilled volunteers to help with it. Thank God for Delphi or it just would not be possible at all.
And let me say thank God for people like...
How do I call a function from another Unit
I have an app with a main form and multiple DataModules.
In the Unit for the main form (MAIN), I have a generic function GetNewId (myTable, myFieldName).
Each DataModule is listed in the Uses clause of MAIN.
Main is listed in the implimentation...
I have a form with a dbgrid, memo and a button. (Unit = main)
I also have a data module with a table (Paradox) and datasource. (unit = dm1)
I want to do three things:
1. display contents of table in dbgrid.
2. on datasource.updatedata and datasource.change I want to update a concantinated...
I need to build (for the lack of a better name) a 'Correspondence Response Engine.'
What it does: Allows us to rapidly create a response to incoming email correspondence. Many people ask the same questions. So we save our responses in a database table sorted by catagory catagory and...
I'm a PHP newby.
I'm trying to find a PHP/mySQL Shopping cart that is EASY TO INSTALL and get running. It needs to calculate sales tax if <state> = CA as well as have some way to calculate shipping costs (non-arbitrary). Did I mention that it needs to be EASY TO INSTALL?
I will 1st need to...
I have apache 2.0.35, PHP4, ... on a win98 server.
I have an HTML form info.html:
<BODY>
<FORM ACTION="displayit.php" METHOD="POST">
Your first name:<BR>
<INPUT TYPE="text" NAME="fname" SIZE="20" MAXLENGTH="30">
Your last name:<BR>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.