Ask a Question related to Coldfusion Database Access, Design and Development.
-
Shane #1
database help
I'm designing a program with a database of employees. I want to have a list
of names that the user can select. When one is selected, I want the
employee's info and a picture to display on the stage. There are more than
500 employees, so I need some kind of database. I know some lingo, but I'm
not pro. And allot of the xtras I've seen are kind of complex to understand.
I don't mind sinking my teeth into an xtra and learning it, as long as it
works. Any suggestions?
Thanks,
Shane
Shane Guest
-
MySQL Database not retrieving the full database
Hi, I am using MySQL and PHP for my repository. It has 500+ records. till now it was displayiing all records in the database, but since from one... -
Import Data from flat-database to relational-database
Before I start I need some tips and pleas excuse my bad english. I have two databases, one is flat and one is a relational database. example ... -
NEWBIE HELP Import Data from flat-database to relational-database
I want to import Data from a simple Database, which contains all Information in one big record into a relational Database and split up the big... -
Passing database info to page allow user input then pass into another database
Hi I really am going crazy! I'm using VBScript, ASP, and SQL My page reminds me of a shopping cart but looking at shopping cart examples has not... -
Another user has modified the contents of this table or view; the database row you are modifying no longer exists in the database;
Hi, I am testing a trigger that and I am getting this error message saying "Another user has modified the contents of this table or view; the... -
Word of Mouth Productions #2 Re: database help
Well, 500 isn't that large a db so maybe you could pass on the complexity of
access and datagrip or some other DB and Xtra pair and put it all into a tab
delimited text file. It would be slower but if you read everything into a
property list when the program starts, it won't be so slow during runtime.
Of course, if you need a two way interface, one that offers information as
well as one that allows editing it would be a bit more complex.
Most db programs allow you to embed image files but if you were to take the
text file route you would just use the file name as an entry and then when
you're ready to display it, use fileXtra4 or some other xtra to insure that
the file exists before trying to display it.
--
Craig Wollman
Word of Mouth Productions
phone 212 724 8302
fax 212 724 8151
[url]www.wordofmouthpros.com[/url]
"Shane" <shoffa@firstgencom.com> wrote in message
news:bnjtr1$t7$1@forums.macromedia.com...list> I'm designing a program with a database of employees. I want to have aunderstand.> of names that the user can select. When one is selected, I want the
> employee's info and a picture to display on the stage. There are more than
> 500 employees, so I need some kind of database. I know some lingo, but I'm
> not pro. And allot of the xtras I've seen are kind of complex to> I don't mind sinking my teeth into an xtra and learning it, as long as it
> works. Any suggestions?
>
> Thanks,
> Shane
>
>
Word of Mouth Productions Guest
-
mrgrphx #3 Database help
I am a very experienced graphic design who is just a mid to high level flash
designer but with no back end experience, I need someone who is experienced
with flash and database. I have a mini version of ebay like where people get to
showcase their items, if you can help please e-mail me at [email]hani@mrgrphx.com[/email]..
mrgrphx Guest
-
erinthien #4 Database Help
:(
Hi, my name is Erin. I'm a student and right now i'm learning coldfusion. I
have a problem with a project. My project is to Extract data from a database(in
coldfision). I have to create two set of date ranges(where user will be able to
select from a drop down menu) then extract data for that two set of date
ranges. I was able to create the drop down menu with dates for the user to
select,but i can 't extract or retrieve data for them. If anyone know how to do
that, please help! here is my code:
Thank YOU!
<cfparam name="FORM.Beginmonth" type="string" default="">
<cfparam name="FORM.Begindate" type="string" default="">
<cfparam name="FORM.Beginyear" type="string" default="">
<cfparam name="FORM.Endmonth" type="string" default="">
<cfparam name="FORM.Enddate" type="string" default="">
<cfparam name="FORM.Endyear" type="string" default="">
<cfparam name="FORM.Beginmonth2" type="string" default="">
<cfparam name="FORM.Begindate2" type="string" default="">
<cfparam name="FORM.Beginyear2" type="string" default="">
<cfparam name="FORM.Endmonth2" type="string" default="">
<cfparam name="FORM.Enddate2" type="string" default="">
<cfparam name="FORM.Endyear2" type="string" default="">
<cfset Date1 = "#Beginmonth#/#Begindate#/#Beginyear#">
<cfset Date2 = "#Endmonth#/#Enddate#/#Endyear#">
<cfset Date3 = "#Beginmonth2#/#Begindate2#/#Beginyear2#">
<cfset Date4 = "#Endmonth2#/#Enddate2#/#Endyear2#">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>form</title>
</head>
<body>
<form name="form" action="form.cfm" method="post">
<form name="form">
<select name="Beginmonth">
<option value="1">January </option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="Begindate">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="Beginyear">
<option value="64">1964</option>
<option value="65">1965</option>
<option value="66">1966</option>
<option value="67">1967</option>
<option value="68">1968</option>
<option value="69">1969</option>
<option value="70">1970</option>
<option value="71">1971</option>
<option value="72">1972</option>
<option value="73">1973</option>
<option value="74">1974</option>
<option value="75">1975</option>
<option value="76">1976</option>
<option value="77">1977</option>
<option value="78">1978</option>
<option value="79">1979</option>
<option value="80">1980</option>
<option value="81">1981</option>
<option value="82">1982</option>
<option value="83">1983</option>
<option value="84">1984</option>
<option value="85">1985</option>
<option value="86">1986</option>
<option value="87">1987</option>
<option value="88">1988</option>
<option value="89">1989</option>
<option value="90">1990</option>
<option value="91">1991</option>
<option value="92">1992</option>
<option value="93">1993</option>
<option value="94">1994</option>
<option value="95">1995</option>
<option value="96">1996</option>
<option value="97">1997</option>
<option value="98">1998</option>
<option value="99">1999</option>
<option value="00">2000</option>
<option value="01">2001</option>
<option value="02">2002</option>
<option value="03">2003</option>
<option value="04">2004</option>
<option value="05">2005</option>
</select>
TO
<select name="Endmonth">
<option value="1">January </option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="Enddate">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="Endyear">
<option value="64">1964</option>
<option value="65">1965</option>
<option value="66">1966</option>
<option value="67">1967</option>
<option value="68">1968</option>
<option value="69">1969</option>
<option value="70">1970</option>
<option value="71">1971</option>
<option value="72">1972</option>
<option value="73">1973</option>
<option value="74">1974</option>
<option value="75">1975</option>
<option value="76">1976</option>
<option value="77">1977</option>
<option value="78">1978</option>
<option value="79">1979</option>
<option value="80">1980</option>
<option value="81">1981</option>
<option value="82">1982</option>
<option value="83">1983</option>
<option value="84">1984</option>
<option value="85">1985</option>
<option value="86">1986</option>
<option value="87">1987</option>
<option value="88">1988</option>
<option value="89">1989</option>
<option value="90">1990</option>
<option value="91">1991</option>
<option value="92">1992</option>
<option value="93">1993</option>
<option value="94">1994</option>
<option value="95">1995</option>
<option value="96">1996</option>
<option value="97">1997</option>
<option value="98">1998</option>
<option value="99">1999</option>
<option value="00">2000</option>
<option value="01">2001</option>
<option value="02">2002</option>
<option value="03">2003</option>
<option value="04">2004</option>
<option value="05">2005</option>
</select>
<br>
<br>
<br>
<br>
<select name="Beginmonth2">
<option value="1">January </option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select name="begindate2">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select name="Beginyear2">
<option value="64">1964</option>
<option value="65">1965</option>
<option value="66">1966</option>
<option value="67">1967</option>
<option value="68">1968</option>
<option value="69">1969</opti
erinthien Guest
-
vkunirs #5 Re: Database Help
Hi
You are unable to get the user selected dates. right?
Are using any form to submit these dates.
if yes. then in the action page write the code as like this:
<cfoutput>
#form.FORM.Beginmonth#
#FORM.Begindate#
#FORM.Beginyear#
#form.Endmonth#
#FORM.Enddate#
#FORM.Endyear#
<cfoutput>
and you must use the one form to get these variables.
and reomve this line:
<form name="form">
vkunirs Guest
-
erinthien #6 Re: Database Help
Thank you very much! I'll try that to see if it work.
erinthien Guest
-
Steve-DDOTS #7 Re: Database Help
you need to send this form to a '_post' template where the data is extracted.
You have: <form name='form' action='form.cfm' method='post'> Action needs to
be something like 'addCustomer_post.cfm' Then create that template to actually
pull the data via a query. <CFQUERY DATASOURCE='#SS_Datasource#'
NAME='GetData'> SELECT * FROM myDataFile WHERE DataDate >='#StartDate#' AND
DataDate <= '#StopDate#' </CFQUERY>
Steve-DDOTS Guest
-
Steve-DDOTS #8 Re: Database Help
Of course, SS_datasource is the name of your data source.
Steve-DDOTS Guest
-
UltimatePhoenix #9 Database Help
Hi, I am putting together a project that will be displaying different types of
media. We would like to build the site with flash and have flash pull its data
from a database. I know this can be done but i am curiouse as to the best type
of database to use would be, i.e. access mysql whatever. What is easiest,
fastest most reasonable. what ever you can tell me would be great.
-UltimatePhoenix
UltimatePhoenix Guest
-
LuigiL #10 Re: Database Help
You don't mention the server side software you are going to use to access the
database. So, beware, Flash cannot connect directly to a database. In my
opinion you should first decide on the server side software. Basically you
could use any database but ASP and .Net work best with MSSQL, PHP can connect
to a lot of databases but the combination PHP/MySQL seems a natural choice. If
you are going to use CF, well you understand what I'm saying. One thing: do not
use Access. Only if you thrive on problems.
LuigiL Guest
-
-
-
FuseFlash #13 Re: Database Help
Whoa! PHP natural Choice?? :o
I disagree on the PHP front - Coldfusion is by far,, a more "natural" choice.
:)
MySQL - Yes very good choice. But if you don't already have knowledge of data
integration into Flash , trust me go with Coldfusion - I have yet to find a
database that it can't handle. As for working with Flash - EASY!!! Using
Remoting Connectors or Web Service Connectors and Coldfusion Components is a
VERY good path to follow.
;)
FuseFlash Guest
-
LuigiL #14 Re: Database Help
No, not PHP as the natural choice. If you use MySQL as a database then PHP
seems (seems NOT is) a natural choice since the two are 'close friends' which
is proven by the thousands of setups with these technologies. When keeping it
in the family, yes, CF is (NOT seems) the natural choice but you have to have
the cash...
AND, my answer wasn't about preference for a platform, it was a pointer to
decide on the server side software first and then decide on a database. People
have to do the research themselves and decide on what technology to use. I'm
not in favour of any technology (besides Flash that is...).
LuigiL Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
