This is the full error,
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '='.
SQL = "select * from ib_...
Write now the dates due to the code below get entered in the database in the format: 'yyyy-mm-dd' despite the fact that I have defined the format as 'yyyy-mm-dd hh:mm:ss'. Can someone pleas...
Hello Experts.
I have in a form a select tag.
This is onload disabled.When someone makes a selection and on submit the form does not pass the validation and the page loads this tag is disabl...
I am trying to implement cfgrid This part is wrking . What i am trying ot do is once the grid is loaded click on the or and get redirected to a diff page . I aknow that it has to be some JS he...
I have been working on this issue off and on for some time now. We are running Coldfusion 4.5, Crystal Enterprise 8.5 and Oracle 9.2 DB on a Windows 2000 Enterprise server. We were scheduled...
Hello experts.
I have a working code for uploading and resizing one image.
Now i want these to work for more than one image and
get the values of the uploaded images and thumbs into a DB.
...
Second cfImage bug I've found in a week. Tried reporting it to Adobe, but their bug report form throws a 404 (nice). Can anyone else verify this?
Basically, certain JPGs will cause CF (or m...
Hi all!
I can't see what's going wrong here people, i have a MySQL data base that stores the name of the image while the image is stored in a temp folder on the server. The problem is wh...
Hi, am describing part of Return Authorization process. There are two screens that I am dealing with: on the first one I display a drop down list with contract numbers; after picking a number...
Hi guys,
I have some log files that are generated and stored on a Windws XP Home edition (I know Home edition). I have made the folder containing the log files a windows share which is acc...
i have three select menus i want to combine into one value and then insert into a DB.
The three values i have are for selecting date of birth
they are
#dobMonth#
#dobDay#
#dobYear#...
I am calling a web service that needs a date parameter passed, the data type is java.util.Calendar
I have tried a great variety of formats and seem to be unable to convince the method I am ...
I wish to run a query dependant on the filename of the current page. ie check weather the current filename is index.cfm or page2.cfm.
Is there a CF function to return this, can you provide sa...
Hi All,
Hope somebody can help with this one.
Have a query in MS Access as follows...
INSERT INTO [MAINTENANCE LOG FAULT CALL MEMOS] ( [Job Reference], [Action Code] )
SELECT 141470 ...
I have a query that finds the data type of a certain field in a database (MSSQL 2005), however it only works if my DataSource name is identical to my Database Name. I need a way to find out t...
I am trying to finish a module on our homegrown CMS system that our developer never finished. I am pretty sure that what I want to do can be done, but I don't know how to do it.
Essentially...
Hi all,
I'm trying to strip all text from a string excluding anything within brackets (<.....>).
Here is a sample string: 211 - 215, London Road ST4 5RW <10675347>
Using the regex state...
Hi all!
I'm having dificulty creating a secure login page for my CF application. I have created a database table in MySQL called 'users login', and have several tables in there containing 3 ...
Have a site that was previously done in cf and now done with html extensions. How should 301 redirects be handled with this situation
I searched the site and I *KNOW* there's an solution for this. I have 2 cfinput datefields stacked on top of each other in a form. (yes, using a table if that matters - yes bad coding, I know...
Hi There,
I'm sure this problem is very simple I just can't find out what I'm doing wrong. Need to insert a single value into a MS Acces database however both the TABLE NAME and the FIELD N...
I have a form with the following information set,
<form id="form2" name="form2" method="post" action="<cfoutput>http://#CGI.SERVER_NAME#/index2.cfm?id1=#trim(GetInfo.IID)#&id2=#form.user2#</c...
Hello experts.
I have a table artikel with columns:
art_ID (primary) test foto1
Now i want on my page the foto1 values from the last 4 art_ID.And because the default value is ima...
What is the best (easiest) way to get the length of a wav file. I don't want the
file size, I can get that with CFDIRECTORY. I want the length of the audio in
time.
I found a tax ca...
I call a webservice and get the totalResults and then loop through webservice and attempt to retrieve all the results and dump it into a database. The webservice will only return a max of 100...
