ObjectDAO

ObjectDAO

ObjectDAO

I read Object data from a MySQL4 database.

Metadata

Instantiating 

	        

	    
	


CreateFarcryPackage()

		
Arguments

        

          
            

              Name
              Type
              Required
              Default
              Options
              Description
            

          
          
	
	            

	              typename
	              string
	              Yes
	              
	              
	              
	            

			
	            

	              DSN
	              string
	              Yes
	              
	              
	              I am the CF datasource name
	            

			
          
        

	
getCfDataType()
I translate the MSSQL data type names into ColdFusion data type names

		
Arguments

        

          
            

              Name
              Type
              Required
              Default
              Options
              Description
            

          
          
	
	            

	              typeName
	              string
	              Yes
	              
	              
	              I am the type name to translate
	            

			
          
        

	
getCfSqlType()
I translate the MSSQL data type names into ColdFusion cf_sql_xyz names

		
Arguments

        

          
            

              Name
              Type
              Required
              Default
              Options
              Description
            

          
          
	
	            

	              typeName
	              string
	              Yes
	              
	              
	              I am the type name to translate
	            

			
          
        

	
getDBObjects()

		
Arguments

        

          
            

              Name
              Type
              Required
              Default
              Options
              Description
            

          
          
	
	            

	              DSN
	              string
	              Yes
	              
	              
	              I am the CF datasource name
	            

			
          
        

	
getDefault()
I get a default value for a cf datatype.

		
Arguments

        

          
            

              Name
              Type
              Required
              Default
              Options
              Description
            

          
          
	
	            

	              sqlDefaultValue
	              string
	              Yes
	              
	              
	              I am the default value defined by SQL.
	            

			
	            

	              typeName
	              string
	              Yes
	              
	              
	              I am the cf type name to get a default value for.
	            

			
	            

	              nullable
	              boolean
	              Yes
	              
	              
	              I indicate if the column is nullable.
	            

			
          
        

	
readFields()
I populate the table with fields.

		
Arguments

        

          
            

              Name
              Type
              Required
              Default
              Options
              Description
            

          
          
	
	            

	              qObject
	              query
	              Yes
	              
	              
	              
	            

			
          
        

	
readObject()
I confirm that this object exists at all.  If not, I throw an error.

		
Arguments

        

          
            

              Name
              Type
              Required
              Default
              Options
              Description
            

          
          
	
	            

	              DSN
	              string
	              Yes
	              
	              
	              I am the CF datasource name
	            

			
	            

	              ObjectName
	              string
	              Yes
	              
	              
	              I am the object to check on.