As I stated in this post, I have only been with the company about 5 months so I'm not sure how much input I will have in this decision to migrate the site to Drupal. From what little I know about this decision, the main reason to use Drupal was because the company wanted the website to become an e-commerce site. I’m not sure what that has to do with Drupal but it should be interesting to find out what mind-set is going on here! The up-keep and maintenance of the current CF website has been lacking for a few years now, so there is quit a bit of work to be done to clean up the site. But it still seems to me that instead of handing this well established ColdFusion website with over 10,000 pages to an outside company called Drupal Connect, the more logical way to go is to clean up the existing site and then set up a CF shopping cart. Did I mention the MS sql Server database with over 75 tables containing over 200,000 records!

I can’t speak for others, but as a web developer, working with any CMS like Drupal or Joomla is like working with my hands tied behind my back. Because the CMS does the coding behind the scenes, it’s so much more difficult to figure out what the issue is when something goes wrong (and things will go wrong!). Not to mention the huge affect this will have in regards to the 1000’s of back links and bookmarks and the over 40,000 unique visits per month we receive now. Does anyone else out there think this may be a huge mistake for this company?
So whats your take on this?

There are 3 querys
The third query on line 30 is the one throwing the error.

Here is the URL that the image tag is attempting to reference.
http://backpacklab.c...ages/100013.JPG
I will do a CFDUMP and let you know what I get.

thanks

Here is my new code. First is the error information from CFDUMP
This is a MS access database and all field data types are set to TEXT except the ID (auto number)
ErrorCode: 3079 [empt string]
Message: Data type mismatch in criteria expression.
SQLState: [empty string]

array 1
struct
ID: cfquery
line: 27
type: CFM
-------------------------------------------------------------------------------------------
SQL
INSERT INTO users (id, username, pass, roles, state, country, email, city)
VALUES ( '' , 'un' , 'pass' , '1234' , 'Alaska' , 'United States' , 'email' , 'city' )
-------------------------------------------------------------------------------------------
form page:

<cfform action="TeachRegFrmAct.cfm" method="post" name="teachRegister">
    <cfinput name="username" type="text" size="20" required="yes" message="please enter a username">    
    <cfinput name="pass" type="text" size="20" required="yes" message="Please enter a password">
   <cfinput name="city" type="text" size="20" required="yes" message="Please enter city">
 <select size="1" name="state">
		<option>Please Select</option>
                                <option>Alabama</option>
                                <option>Alaska</option>
                                <option>Arizona</option>
</select>
<select name="country">
        <option value="United States" selected="selected">United States</option>
        <option value="Afghanistan">country 2</option>
        <option value="Albania"> country 3 </option>
        <option value="Algeria"> country 4 </option>
</select>
<cfinput name="email" type="text" size="20" required="no">
<cfinput name="roles" type="text" size="10">
<input type="hidden" name="id" value="" />
    <input type="hidden" name="register" value="member"> 
    <input name="submit" type="submit" value="Register" />
</cfform>

action page:

<cftry>
 <cfset CurrentPage=GetFileFromPath(GetTemplatePath())>
<cfif IsDefined("FORM.register") AND FORM.register EQ "member">
<cfquery datasource="backpacklab">
   INSERT INTO users (id, username, pass, roles, state, country, email, city) 
   VALUES
   (
'#FORM.id#' ,
'#Trim(FORM.username)#'  ,
'#Trim(FORM.pass)#'    ,
<cfif IsDefined("FORM.roles") AND #FORM.roles# EQ "1234">
'#Trim(FORM.roles)#'
<cfelse> NULL</cfif>   ,
'#Trim(FORM.state)#'   ,
'#Trim(FORM.country)#' ,
<cfif IsDefined("FORM.email") AND #FORM.email# NEQ "">
'#Trim (FORM.email)#' <cfelse>NULL</cfif>  ,
'#Trim(FORM.city)#'
 )
  </cfquery>
  </cfif>
  
  <cfcatch type="Database">  
<cfdump var="#cfcatch#">  
<cfabort>  
</cfcatch> 

</cftry>

exiles.prx, on 04 April 2012 - 12:18 PM, said:

If the image is being used as a background image than he will not be able to make an image map out of it.

There is a way to make the cell of a table into a link also but again, he needs 2 seperate links so his only option is to not use the image/images as a background.