Search results for query: *

Hello all, I have an automated process that usually works, but occasionally it doesn't. I'm using the query below to load data hourly into a MySQL table from a tab-delimited file. Most of the time it works fine, but every once in a while the complete file does not load. When that happens I go...

Hi guys, this is my first time in this group, so be gentle. I don't work with Oracle everyday, so I could use an assist here. I need to write a query that will select all fields in a specific view, but only look backwards four days. How might I do that?

I have a query that does a simple LEFT JOIN to determine whether there's a match in a second table. My problem is that the comparing column on the left side might be different depending on the data in another column. Here's the skinny: the data are being loaded from a file list on our server...

Hello all, I'm having a problem with an update using this query: DROP TABLE IF EXISTS test_table; CREATE TABLE test_table ( pk_newline_id INT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY (pk_newline_id), level_01 VARCHAR(255) default '0', level_02 VARCHAR(255) default '0', level_03...

Hi group, I'm trying to put together a calculation that examines the current day and then appends the appropriate "st", "nd" or "rd" for some legalese stuff we're doing (e.g., "This 30th day of April 2007). Problem is, it doesn't seem to evaluate the entire string and I can't quite figure out...

We're using Filemaker 8, and we're working with a solution that draws company data for drop-down lists that our users will use to complete a form on their Macs. The data are drawn from 1 of 2 possible FMP files (the file on their Mac, or a file hosted on a FMP8 Server). Users of this...

OK, I'm fairly new to XML and FileMaker. I keep getting an error: "XML Parsing Error: The main document cannot be empty". I'm a little fuzzy on the syntax. The import I'm trying to accomplish has three parts: the FMP database, an XML output file from a third-party program that churns out...

OK, here's an interesting one. I have a solutiuon that was created by a third-party developer. It contains a global field whose value serves as the key to a relationship for various different report formats. What it does is really irrelevant here. Here's what's curious: at startup it has a...

In the SQL world I can run write a query with a DISTINCT argument to aggregate values in a particular column. Does FMP have a similar function? I need to be able to set all the possible values in any given field into a global field. I know it's possible to export values from a field once they...

This is a simple one (I hope). I've created a simple movie with a few pictures fading in-out-rotating. I also have text on layers that move in and out of the stage at timed intervals. When I export the movie to a MOV file, it works fine. But when I export to a SWF there's no text. I read...

I recently installed MySQL 4.1 and CF7, but I'm having trouble with the driver connection. I'm trying to use MySQL's connector J v. 3.0.17 but I haven't had any luck. I also tried with the latest driver, mysql-connector-java-3.1.11-bin, but it didn't work and read on one of the CF message...

I recently installed MySQL 4.1 and CF7, but I'm having trouble with the driver connection. I'm trying to use MySQL's connector J v. 3.0.17 but I haven't had any luck. I also tried with the latest driver, mysql-connector-java-3.1.11-bin, but it didn't work and read on one of the CF message...

Hi folks ... any help here is appreciated. I just finished a messy Windows XP/IIS/CF7 reinstall and I've run into a load problem for cfm files. The bearings on my old hard drive burned out and when it died it took everything with it. Here's what I've got: WinXP Media Edition, IIS6, CF7 and...

I'm wondering how to run a query using the results of a previous query. I have a page that queries a table on a date range specified by the user and passed to the page via URL variables (see below). <cfparam name="start_date" default="URL.start_date"> <cfparam name="end_date"...

I'm sure I'm missing something simple, but if someone could show me where I'd appreciate it. I'm running what I thought was a fairly simple CFIF-based conditional that doesn't seem to work as I hoped. The Form.date parameter is being passed, and my database has two records dated 2005-07-15...

I have two tables, WIDGETS and VERSIONS. The WIDGETS table has descriptive information about the widgets while the VERSIONS table contains IDs relating to different iterations of those widgets over the years. The idea is that from any widget in the database you can look forward and backward to...

OK, here's another query that worked OK in 3.2 that doesn't in 4.1. This query inserts a date period for a report program we have running in ColdFusion. The values for the insert are being passed from a form to the action page that the query below is on. <CFQUERY...

We recently upgraded to ColdFusion 7 and MySQL 4.1, and the query below -- which worked fine under CF5 and MySQL 3.2 -- is failing now. Based on the error (below) it looks like a query error, but after going through the 4.1 docs I still can't see the problem. Any ideas why it's failing...

We recently upgraded to CF7 and MySQL 4.1, and the query below -- which worked fine under CF5 and MySQL 3.2 -- is failing now. Based on the error (below) it looks like a query error, but after going through the 4.1 docs I still can't see the problem. Any ideas why it's failing? <cfquery...

I'm sure this is easy, but I can't figure it. I keep getting an error on this saying that 'Initial' is an unknown column in the where clause. SELECT system, acronym, id, year, cat, acronym, LEFT('system', 1) AS initial FROM csap WHERE year = '2004' AND initial = 'a' ORDER...