Recent content by kingjjx

I am doing a ... <cfoutput>#date#</cfoutput> what comes out is: 1900-01-01 00:00:00 how do i cut/trim out the 00:00:00 ??? thanks

I have 2 tables .. a customer table and a auto_rental table. the common field between the 2 table is the customer# field. an auto is assigned a customer#, once a customer rents the auto .... what i want to do is be able to take out that customer number once the customer has returned the auto...

yes, this is the same process. if you wanna look at what im trying to do: http://dynamic.dynojet.com/cfml/tuninglink/search_tl.CFM (type in: advance) HOW DO I CONVERT DATA ???? Im not even carrying data over from the other table with the field that I am having problem with. Basically, I...

Hi, can some one tell me what this error message means ?? I have a field in my table called amount which is set to data type 'money' I created a form to insert values to that table and its giving me this error :: Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access...

hey, thanks guys .. i finally figured out how to solve the problem. i just queried the 1st table, took the values that i needed then inserted it to the 2nd table. thanks !!

hi, what if table A and table B does not have a matching key ? what im trying to do is get the customer number from table A and input it in table B. so, what I am trying to do is query table A, then add an EDIT button with the query result , then in the EDIT page, once the user clicks submit...

How do I do the join statement ? Basically, the ArCustomer table contains the customer name and number and the rest of the info i need is in the TuningLinkIssues table.

Hi, Im wondering whats wrong with my code ... If I use this 1st set of code below .. it gives me the right results .... <cfquery name=&quot;shit&quot; datasource=&quot;EncoreCompanyD&quot;> SELECT ArCustomer.Customer, ArCustomer.Name FROM dbo.ArCustomer WHERE...

Hey .. I just changed the WHERE clause to ... WHERE O.name = c.name Now, the error message is : ODBC Error Code = IM002 (Data source not found and no default driver specified) [Microsoft][ODBC Driver Manager] Data source 'MYDSN' not found and no default driver specified I guess this is...

Hi, this is what my final code looks like ... <cfquery name=&quot;myQuery&quot; datasource=&quot;myDSN&quot; dbtype=&quot;ODBC&quot;> SELECT O.name, C.name, C.customer FROM DynoOwnersRec.dbo.dyno O INNER JOIN EnCoreCompanyD.dbo.ArCustomer C ON O.name = C.name WHERE...

Hi, I am running 4.5 version ... I'm trying to use the first example you posted ... <cfquery name=&quot;myQuery&quot; datasource=&quot;myDSN&quot; dbtype=&quot;ODBC&quot;> SELECT O.OrderNumber, O.OrderDate, C.CustomerName FROM dbOrders.dbo.tblOrders O INNER JOIN...

Hi, can someone tell me how to query from 2 datasources ?? I want to query from 2 separate database .. i already set up datasources for each. thank you -jon

Hi, I need help on a simple form im trying to create. I have a registration form where a user can create a username and password then submit it and it will input it in the database. However I want to add a text box for the user to RE-ENTER HIS PASSWORD to make sure he didnt do a typo...

How can I encrypt my coldfusion code so no one can understand/ edit it ? I downloaded a demo version of a program created in coldfusion and parts of it were encrypted. I opened the source code and It looked like chinese characters ... how can i do this ?? thanks -jon

HEY, I GOT THIS TO WORK .. SO THANKS FOR YOUR HELP.