Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jmcg
  • Content: Threads
  • Order by date
  1. jmcg

    iframe form with parent refresh

    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?
  2. jmcg

    Creating Excel XML from CF

    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...
    • jmcg
    • Thread
    • Replies: 0
    • Forum: Adobe
  3. jmcg

    CFDOCUMENT PDF & Javscript

    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"...
    • jmcg
    • Thread
    • Replies: 0
    • Forum: Adobe
  4. jmcg

    Outputting Query records from within loop

    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 *...
    • jmcg
    • Thread
    • Replies: 5
    • Forum: Adobe
  5. jmcg

    Elevate Rights via SQL

    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
  6. jmcg

    CFUPDATE to ignore fields

    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
    • jmcg
    • Thread
    • Replies: 3
    • Forum: Adobe
  7. jmcg

    change textbox attributes on click

    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...
  8. jmcg

    Custom cferror

    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...
    • jmcg
    • Thread
    • Replies: 0
    • Forum: Adobe
  9. jmcg

    Show debugging when disabled on server

    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?
    • jmcg
    • Thread
    • Replies: 3
    • Forum: Adobe
  10. jmcg

    Wait for a webpage to load before calling another.

    Been trying to set up a form that will call a webpage, wait for it to load and then call another page. The pages can take 10-15 mins to load. From other posts I have tried Set IE = Me.WebBrowser IE.Navigate "http://www.google.co.uk" While IE.Busy 'Do nothing Wend While IE.Document.ReadyState <>...
  11. jmcg

    Change SQ Server Owner from Access

    I am trying to call a command to change a table owner to dbo. Our company set-up means that all tables by default are create with my ID as owner. However for other applications that use them they need to owned by the dbo. I have the VBA that creates the table via ODBC and need to know if it...
  12. jmcg

    Drop Column Error

    I am trying to drop a column in my SQL Server 2005 database and getting an error. The code I am running is: ALTER TABLE Targets DROP COLUMN Connections and I am getting the error: The object 'DF___Targets_Conne___25A75D29' is dependant on column 'Connections' Any suggestions to what may be...
  13. jmcg

    Create CF DSN to mySQL database

    I have a mySQL database working fine on my server but was looking to connect on my local CF to test. I have tried to create a dsn using the database name and a user but get an error: Connection verification failed for data source: osTickets java.sql.SQLException: Access denied for user...
    • jmcg
    • Thread
    • Replies: 0
    • Forum: Adobe
  14. jmcg

    Can I page be set to ignore Application.cfm?

    I am looking to set a template to ignore the application.cfm. Is this possible. The page is generated by code to contain a couple of hundred lines of Javascript and I do not want any headers etc from the application to be added as it is being read by cfhttp.
    • jmcg
    • Thread
    • Replies: 2
    • Forum: Adobe
  15. jmcg

    Can these queries be run as one?

    I have been trying to match 2 tables to produce a set of results showing all records from Features and any that match in StockFeatures and to show the CarID. StockFeatures will have other CarID and these should not be returned. View1 SELECT CarID, Feature FROM...
  16. jmcg

    Delete SQL table contents via VBA

    I have a local access database that I send up to an SQL db using: db.Execute "INSERT INTO [ODBC;DRIVER=SQL Server;SERVER=MyServer;DATABASE=MYDatabase].MyTable( Field1, Field2 ) SELECT lclFld1, lclFld2 FROM lclTable and it works fine, however before uploading the new data I need to clear down...
  17. jmcg

    Numeric with decimal point

    I knwo little about javascipt and found this code elsewhere and looking to try to tweek. It works fine in changing the value entered to numbers only but need to allow for a decimal place. Is it possible to change this code to allow for a . decimal function toNumber(checkString) { newString...
  18. jmcg

    CFCONTENT &amp; CFDOCUMENT

    I have a form that allows a user to upload a file to the server, the uploaded file is the shown on the page within an iframe using CFCONTENT. This works fine. I am then trying to use CFDOCUMENT to output the page as a pdf. It works except for the iframe CFCONTENT document which shows No pilot...
    • jmcg
    • Thread
    • Replies: 0
    • Forum: Adobe
  19. jmcg

    Error with blanks and ListGetAt

    I have a form collection data and am using ListGetAt in an update query to save any changes. If a user deletes an entry and then saves I get an error, "Invalid list index 7". If all entries are complete it works fine. The fields are all Text boxes allowing zero lengths so don't think it's the...
    • jmcg
    • Thread
    • Replies: 6
    • Forum: Adobe
  20. jmcg

    All emails sending as bulk or spam

    All emails sent via our Exchange 2003 server are showing as bulk. I don't know much about Exchnage but had tried to change the default SMTP server to our dedicated IP but still showing as bulk. Can anyone offer any advice?

Part and Inventory Search

Back
Top