I have a query like this:
SELECT
P.PageID,P.PageSUB,
CONCAT("L1=" , P.PageID, "&sub=", P.PageSUB) AS thePath
FROM Pages P
What I want thePath to look like is:
L1=12&sub=res
what I get is:
[B@7857a5
It looks like it is Concatenating the field reference or something...
I have a Contacts table and a Notes table, I would like to make a query that gets all of the fields from the Contacts table and also gets the multiple records for that contact from the notes table.
The contacts can have many notes there is a contactID in the notes table to join it to the...
Hey there!
The problem is that you guys are fighting with Access syntax for the SQL.
You can make the joins with just AND's in the WHERE clause.
Try this:
<CFQUERY NAME="getFiles" DATASOURCE="Loaner" DBTYPE="ODBC">
SELECT LN.InputDate, LN.QtyOnHand...
DeusRomulus,
Thanks for your reply but I am doing this on a web server. I am using Cold Fusion to create a PowerPoint Object that will then open and manipulate the PowerPoint slides. So I have to solve this problem programmatically.
I wish there were a parameter to the InsertFromFile Method...
Hello all,
I am using the InsertFromFile method to copy single slides from one Powerpoint presentation to a blank presentation.
I open a blank presentation then I loop through a list of ppt files like this:
mySlides = objPresentation.Slides;
for(i=1; i LTE formQTY; i=i+1){
theSlide = docPath...
There is a web site:
http://www.lipidsonline.org/slides/
that takes PowerPoint slides and displays them individually. You are allowed to select slides from all of the presentations into your own little cart (or tray as this site calles it). When you are finished collecting your individual...
Hey thanks to all who have replied!!
Here is my solution to the dilemma (yucky code to follow):
First I import the Spreadsheet to a TEMP table, then there is an INSERT QUERY that compares the real table (customer_export) to a QUERY that finds the different records between the two tables...
Hello,
I ave a bit of a dilemma. I ahve a client that wants PeachTree data in an Access database. I had the client export the appropriate data from PeachTree (Customers and Inventory). It is quite a simple list of items the customer export has only the customer ID and the Customer Name and the...
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.