String index out of range: 0

Element COMPONENTID is undefined in ALREADYSELECTED.
 
The error occurred in C:\CFusionMX\wwwroot\Project\Beginner\Queries\Queriesc.cfm: line 17

15 : AND TBLSELECTEDCOMPONENTS.COMPONENTID = #ANSWER1#
16 :
17 : <cfif isDefined(#AlreadySelected.COMPONENTID#)>
18 :       UPDATE TBLSELECTEDCOMPONENTS
19 :       SET TBLSELECTED.NUMBERSELECTED = ((#AlreadySelected.NUMBERSELECTED#) + 1)

The error appear and i cannot see why

<!--- Session Variables --->
<cfset session.level = url.level>
<cfset session.type = url.type>
<cfset session.name = url.name>

<cfoutput>
<cfset session.answer1= #Form.ANSWER1#>
</cfoutput>

<cfoutput>
<cfquery name="AlreadySelected" datasource="database">
SELECT TBLSELECTEDCOMPONENTS.COMPONENTID, TBLSELECTEDCOMPONENTS.NUMBERSELECTED
FROM TBLSELECTEDCOMPONENTS
WHERE TBLSELECTEDCOMPONENTS.USERID = #session.name#
AND TBLSELECTEDCOMPONENTS.COMPONENTID = #ANSWER1#

<cfif isDefined(#AlreadySelected.COMPONENTID#)>
      UPDATE TBLSELECTEDCOMPONENTS
      SET TBLSELECTED.NUMBERSELECTED = ((#AlreadySelected.NUMBERSELECTED#) + 1)
      WHERE TBLSELECTEDCOMPONENTS.USERID = #session.name#
      AND TBLSELECTEDCOMPONENTS.COMPONENTID = #ANSWER1#      
<cfelse>
      INSERT INTO TBLSELECTEDCOMPONENTS(USERID, COMPONENTID, NUMBERSELECTED)
      VALUES (#session.name#, #ANSWER1#,1)
</cfif>
 
</cfquery>

</cfoutput>

<cfoutput> <cflocation url="../RAM.cfm?level=#url.level#&type=#url.type#&name=#url.name#"></cfoutput>

The reason that componentID is not defined in AlreadySelected is that you are currently in the middle of running the query that will be assigned to "AlreadySelected" and it hasn't actually been constructed yet. Any time that you're doing an isDefined() check, don't use pound signs, just encompass the string with quotation marks (ie isDefined('AlreadySelected.ComponentID') )

I now have two problems on this means that it keeps going in an endless loop and never getting to move to next component

and when i add the field into test it moves forward a page before outputting

Parameter 1 of function IsDefined, which is now &quot;PCI-E&quot;, must be a syntactically valid variable name.
 
The error occurred in C:\CFusionMX\wwwroot\Project\Beginner\Queries\Queries7.cfm: line 31

29 : <cfset FREEPCI = #MboardPCI.PCI# >
30 :
31 : <cfif isDefined (#GcardInterface.INTERFACETYPE#)>
32 :       <cfif #GcardInterface.INTERFACETYPE# eq 'PCI'>
33 :             <cfset FREEPCI = ((#FREEPCI#) - 1)>

i see with your script here you have #'s used incorrectly

29 : <cfset FREEPCI = #MboardPCI.PCI# >
30 :
31 : <cfif isDefined (#GcardInterface.INTERFACETYPE#)>
32 :      <cfif #GcardInterface.INTERFACETYPE# eq 'PCI'>
33 :           <cfset FREEPCI = ((#FREEPCI#) - 1)>


isdefined() like mkishline mentioned above should not have #'s in it. With the little code I see above in the error output... change those to be...

29 : <cfset FREEPCI = MboardPCI.PCI >
30 :
31 : <cfif isDefined ("GcardInterface.INTERFACETYPE")>
32 :      <cfif GcardInterface.INTERFACETYPE eq 'PCI'>
33 :           <cfset FREEPCI = FREEPCI - 1>

you actually don't need #'s in any of that...

the only time you really need to use #'s is when you're outputing something, otherwise they are not needed...

Hi I seem to have 3 problems left when i place in this bit of code all the possibilities disappear, as talked about 6 comments above i also seem to be stuck in an endless loop at one page

<cfif FREEPCI eq 0>
AND NOT (TBLNETWORKCARD.TYPE = 'PCI')
<cfelse>
AND TBLNETWORKCARD.TYPE = 'PCI'
</cfif>

<cfif MANUFACTURER eq 'Not Selected'>
<cfelse>
AND (TBLCOMPONENT.MANUFACTURER = #MANUFACTURER#)
</cfif>

<cfif NETWORKCARDTYPE eq 'Not Selected'>
<cfelse>
AND (TBLCOMPONENT.TYPE = TYPE)
</cfif>

<cfif DATATRANSFERRATE eq 'Not Selected'>
<cfelse>
AND (TBLCOMPONENT.DATATRANSFERRATE >=# DATATRANSFERRATE#)
</cfif>

and finally if for some reason i click submit and do not choose one of the possibilities it has a hissy fit on most of the pages
 Element ANSWER1 is undefined in FORM.
 
The error occurred in C:\CFusionMX\wwwroot\Project\Beginner\Queries\Queriesa.cfm: line 7

5 : <cfoutput>
6 :
7 : <cfset session.answer1= #Form.ANSWER1#>
8 :
9 : <cfquery name="insertanswer1" datasource="database">

try this instead, just a few syntax corrections


<cfif FREEPCI eq 0>
AND NOT (TBLNETWORKCARD.TYPE = 'PCI')
<cfelse>
AND TBLNETWORKCARD.TYPE = 'PCI'
</cfif>

<cfif MANUFACTURER eq 'Not Selected'>
<cfelse>
AND (TBLCOMPONENT.MANUFACTURER = '#MANUFACTURER#')
</cfif>

<cfif NETWORKCARDTYPE eq 'Not Selected'>
<cfelse>
AND (TBLCOMPONENT.TYPE = TYPE)
</cfif>

<cfif DATATRANSFERRATE eq 'Not Selected'>
<cfelse>
AND (TBLCOMPONENT.DATATRANSFERRATE >= #DATATRANSFERRATE#)
</cfif>

Nope still nothing

<cfparam name="form.answer1" default="" />
<cfset session.answer1= #Form.ANSWER1#>

It may also not be a bad idea to add a little javascript validation to your form to ensure that the user enters some value for the answer1 field. There's no place in the code you're posting that could be an endless loop so the problem is likely with the <cflocation url="../RAM.cfm?level=#url.level#&type=#url.type#&name=#url.name#"> page.

Hi

can u tell me what is wrong in this code. the form field presents the user with a list in a select box. i then only want them to be able to see the submit button when the have selected a value in this list. otherwise do not display the button.  The only issue is that it only seems have an answer value when the form is submitted.

Form field
<select name="ANSWER1" size="5" >
<cfoutput query="processor">
<option value="#processor.COMPID#">#processor.COMPNAME#</option>
</cfoutput>
</select>

Button
<cfparam name="form.answer1" default="" />
<cfset session.answer1= #Form.ANSWER1#>      
<cfif isDefined ("Form.ANSWER1")>
<input name="SUBMIT" type="submit" value="SUBMIT">
<cfelse>
</cfif>

Replace your code with:

<script type="text/javascript">
      function submitOK(selectObj){
            if(selectObj.selectedIndex != 0){
                  document.getElementById('submit').style.display = "";
            }
      }
</script>

<form action="#" method="post">
      <select name="ANSWER1" size="5" onchange="submitOK(this)">
            <cfoutput query="processor">
                  <option value="#COMPID#">#COMPNAME#</option>
                </cfoutput>
      </select>
      <input type="submit" id="submit" name="submit" value="Submit" style="display:none;" />
</form>

Coldfusion does all of it's processing before the information is displayed in the client's browser. Once the information is there, Coldfusion cannot affect the content of the page, to do that you need to use Javascript.

Thanks for everyones help i have one last problem i want to be able to print, email and send the information to a text file.  i have the text file bit working but there is a problem with outputting it properly.  also i am not sure how to use the information show below and email it and print it.

<!--- Session Information --->
<cfoutput>
<cfsavecontent variable="toPrint">
Date: #DateFormat((now()), "ddd, mmmm dd, yyyy")#
User ID: #url.name#
User Level: #url.level#
User Type: #url.type#
</cfsavecontent>
</cfoutput>

<!--- Selected Components  --->
<cfoutput query="getPC">
Output:#getpc.COMPNAME# x #getpc.NUMBERSELECTED#"
</cfoutput>

<!--- Output to a file  there is a problem here with the second part of this output--->
<cffile action="append" file="C:\Documents and Settings\Laura\Desktop\formlog.txt" addnewline="yes"
output="

<cfoutput>#toPrint#</cfoutput>

<cfoutput query="getPC">
#getpc.COMPNAME# x #getpc.NUMBERSELECTED#
</cfoutput>
">