I have to tables we'll call them parent_category and child. What is the best way to delete a parent_category record that has 2 child entries. Should this contain two separate delete queries? Should...
http://www.experts-exchange.com/Database/MySQL/Q_22795572.html
Hi Folks,
I've hit a bit of a stumbling block on how best to achieve this.
I'm trying to output a list of categories for different products, however each field may contain a number of values,...
http://www.experts-exchange.com/Database/MySQL/Q_23152777.html
I basically have a set of checkboxes being populated by a query. I want to take the comma seperated list from the checkbox value and insert each value into it's own row on a one-to-many table. Pl...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/Cold_Fusion_Markup...
The following query named myprojects is only returning 1 result... only the first number in the 'IN' list. I included example numbers below in brackets.
<!--- SELECT MY PROJECTS --->
<cfquery...
http://www.experts-exchange.com/Database/MySQL/Q_23186200.html
Hi Folks,
Joins really aren't my strong point, so I'd be grateful of any pointers with this one.
This is my existing query;
SELECT m.ID, m.shortname, m.retailer_name, o.merchantid, o.id AS...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23499412.html
Zones:
SQL SyntaxDate Answered: 06/19/2008 Grade: A Views: 0
I have inherited an application that has, for some reason, been inserting all information twice. The table was set up with an auto-incrementing primary key though, so it looks much like:
Key ...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/Cold_Fusion_Markup...
Hello there,
I have two issues.. one regarding calculating some values in my mysql tables and secondly how i can display these with CF code.
I have identical tables with different data in mys...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_21798506...
Hi experts,
What I want to do is to have a "Textarea"(within a <cfform>) in my coldfusion page and have the users upload news releases. I don't have the control over how big in size this news re...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20853004...
Hello,
Does anybody have any examples how to import or read xml with Coldfusion and input the data into a table using Coldfusion?
Thanks,
Brian
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/Cold_Fusion_Markup...
Zones:
CFML,
XMLDate Answered: 01/10/2008 Grade: A Views: 8
The following query run flawlessly in localhost but produces error on ISP server:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right...
http://www.experts-exchange.com/Database/MySQL/Q_23329657.html
Zones:
MySQL ServerDate Answered: 05/30/2008 Grade: A Views: 0
