Help with DB driven forms

-

hello,

 

i created 2 select box populated information in sql database works fine. want able have user pick 1 of 2 select boxes , submit request pull information sql database base on selection. result should placed on page called results.cfm display choice i'm having trouble pulling on information. can please guide me in right direction? i've provided code i've got far. appreciated.

 

thanks in advance,

eynar23

 

ps -  i'm looking little guidence want learn how accomplish on own.

******************************************************************************

 

 

<h3>search related area:</h3>


<cfform name="selectchoice" action="results.cfm" method="post">


<cfquery name = "relatedareadrop" datasource = "cssys_issuetracker">

select  value, description

from cs_relatedareas

order value

 

</cfquery>


<cfselect name = "start_end" query = "relatedareadrop" size = "1" value="value">

</cfselect>


<br><br>


<h3>search issue type:</h3>



<cfquery name = "issuetypedrop" datasource = "cssys_issuetracker">

select issuetype

from cs_relatedareas

group issuetype

 

</cfquery>


<cfselect name = "start_end2" query = "issuetypedrop" size = "1" value="issuetype">


</cfselect>


 

<br><br>

<input type="submit" name="submit" value="search">


</cfform>

what mean having trouble pulling information over?  results.cfm do?  should able reference form.start_end or form.start_end2.



More discussions in ColdFusion Rich Forms


adobe

Comments

Post a Comment

Popular posts from this blog

Flip address is out of range arduino uno r3

-
hello  guy, trying flash firmware on arduino uno rev3 atmega 16u2 using atmel flip. whenever try , import .hex file program, throws error " address out of range ." have looked around online , haven't found solution. , info helpful. here hex file : https://github.com/nicohood/hoodloader2/blob/master/avr/bootloaders/hexfiles/hoodloader2_0_5_uno_atmega16u2.hex its using arduino uno hid Arduino Forum > Using Arduino > Installation & Troubleshooting > Flip address is out of range arduino uno r3 arduino
Read more

Arduino DUE ADC to DAC Piezo 30 Khz-100Khz

-
i working on project providing echo response ultrasonic sensors. piezo facing opposite ultrasonic sensor,with foam material in between damp ultrasonic signal reflecting sensor. event based,read piezo signal[(+) --> a0,(-) --> gnd on arduino due] , after delay(5 ms) drive same piezo through dac0 [(+)---> dac0,(-)--> gnd) so ultrasonic sensor receives signal (30 khz-100 khz) after delay,thereby calculating distance after time of flight of 5 ms. int in_adc0,out_dac0;  //variables adc,dac values (adc0, dac0) void setup() {   //adc configuration   adc->adc_mr |= 0x80;   // dac in free running mode.   adc->adc_cr=2;         // starts adc conversion.   adc->adc_cher=0x80;  // enable adc channels 0     analogreadresolution(12);  analogwriteresolution(12);   //dac configuration   analogwrite(dac0,0);  // enables dac0   serial.begin(9600); }   void loop() { ...
Read more

Indesign and MathType fonts

-
i having trouble getting indesign recognize mathtype fonts.  have been told move mathtype fonts on 2 indesign font folder.  copied mt-extra font file mathtype folder , pasted indesign font folder.  nothing changed.  indesign still gives me blank box after copy mt-extra font mathtype -->illustrator-->indesign.   guess need instructions on how transfer of fonts done correctly.  i'v looked @ install fonts manual indesign, not clear me on how it.  need utility fontexplorer this, or there other way.  what's weird working fine until had reinstall osx , reinstall cs3, font trouble started.  need toggle "activate-reactivate' adobe cs3 , don't know how close 20 max on this, worried that.  (i suspect because of note on forum might necessary).  thoughts appreciated. i'm using windows, advice may worth nothing...   1) shouldn't have deactivate id recognize fonts. 2) design science gives fonts away in type 1 , truetype flavors....
Read more