Search results for query: *

BillyRay Thanks, that has put my in the right direction. Rather than a reload I have used the href to point to a URL. Cheers

Sorry Dan, not sure I'm really following that one. Bit inexperienced with Javascript. The iframe appears on the page before submission to aloow submission then after to allow another submission but is in fact resubmitting the previous data. Not sure if that makes it any clearer.

I have a form within an iframe that submits the data, then refreshes the parent (using parent.location.reload();). However as the iframe is part of the refresh is goes into a loop of resubmitting the data. Is there anyway to stop this from happening?

I have created a workbook with 6 worksheets and all works fine. I am now looking to create a summary based on the queries that ran to create the 6 sheets. However I need that worksheet to be first in the list, even though it will be created last. I know I could rerun the queries but would rather...

I am trying to use CFDOCUMENT to create a pdf file with an embedded link to the goolge maps API. I use the code <script src="http://maps.google.com/maps?file=api&#Chr(35)#038;v=2&#Chr(35)#038;key=ABQIAAAAGObV6T8B_zpXgwVZWvNwuxQQCKZWhYPeOwJCc-_-DB9RAo9IthR-zOOdtE6I-G8eSTKCApqMjo44Ig"...

I had that at first but got a stranger error message and thought it was just a typo from cfSearching ;-) Also a couple of typos on my post index="x" is actually index="col". The error message without the inverted commas was: [Table (rows 93 columns CREATEDDATE, SAC, SACNAME, CREATORNAME...

Am on CF7 so have used the following. <cfset colArray = "listToArray(ValueList(outputCols.colRef))"> <cfloop from="1" to="#ArrayLen(colArray)#" index="x"> <td>allData[col][currentRow]#</td> </cfloop> And get an error of: Object of type class java.lang.String cannot be used as an array The...

I have a query that returns all data from a table I then have a sub query that defines which columns should be output on the screen. I want to be able to output data columns from the first query based on the relevant cols in the output data. <cfquery datasource="#DSN#" name="allData"> SELECT *...

public to db_owner

Is it possible to elevate a user rights via an SQL storedprocedure. I do not have Enterprise Manager and can only access via an Access ADP. Is this possible, it is SQL Server 2005

thanks will try the formfields to defined rather than exclude. Or better yet spend a few hours and sort it into a proper SQL as CFUPDATE is not very good. Thanks for the tips anyway.

IS there a way to have CFUPDATE ignore certain fields in the form. I am using CFUPDATE as there are too many changeable form fields (of different types) to write the SQL manually, however want to ignore some fields that do not exist in the table. Is this possible, and if so, how? Thanks

Got it working with function changeInput(obj) { obj.style.background = "99ccff" ; } <input type="text" name="Contact_First_Name" value='#Contact_First_Name#' size='#len(Contact_First_Name)+4#' onClick="changeInput(this);return true;"> Thakns to all for the help

Sorry the code to call should read: <input type="text" name="Contact_First_Name" value='#Contact_First_Name#' size=#len(Contact_First_Name)+4# onClick=" changeInput(this);">

I am trying to get a bit of code that will change the background color and change the size of a textbox when it is clicked on. The Javscript function is (for just the color): function changeInput(this) { document.getElementById(this).style.backgroundcolor = "silver" ; } and the code to call...

I am using a customer cferror page which includes the default classic.cfm debug page. This works ok, but what I ideally wanted was to be able to use the classic.cfm output into a file or field to log the error. I have tried using a textarea but there is some default code in the debugging that...

Thanks cfSearching, you've confirmed what I thought.

Debugging is disabled on the development server I use (no idea why but have asked for it to switched o and been told it is policy to have it off!) What I wanted to know was if it as possible to switch it on with the CF template to view the debug output?

It got me there anyway

Thanks for hanging in there on this. Changed to the above code and to a Load Event and it did not work However when I changed the 4 back to "Complete" it did work! Private Sub Form_Load() On Error GoTo 0 Set IE = Me.WebBrowser2 IE.Navigate "http://www.google.co.uk" While IE.Busy...