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: mrsbean
  • Order by date
  1. mrsbean

    table border/td border

    I'm want to make a table border by changing only the style for table which will give me both the interior and exterior borders. I need to do this with style sheets and not with traditional html (<table border="1" bordercolor="blue" ...) method. border-color: blue; border-style: solid...
  2. mrsbean

    changing from Access database to MySQL

    I have multiple Access databases which are used across many websites on our server. I want to move the data into MySQL. I know that Access handles dates differently than MySQL (#MM/DD/YYYY# vs 'YYYY-MM-DD'). I have hundreds of pages of code which would probably have to be changed. I want to...
  3. mrsbean

    format a number with leading zeroes

    I need to format the output of a number so that it is always 3 digits with leading zeroes. For example, the stored value might be 7. I would want to show that number as 007. The number is not a date/time value ... When I poked around looking for a formatting tutorial which would show me how...
  4. mrsbean

    odbc dialogue box missing in action

    I want to export some Access tables to an instance of MySQL on localhost. I have tried several times to use Export (right click on the table name and select export, select ODBC from the drop down list). It assumes I want to name my table in the ODBC source the same as the local table which is...
  5. mrsbean

    Compact and Repair Access Database

    Thanks for your input ... I know there is a way to do this with ASP, but I'm wondering if even that method depends upon having the Access program or runtime installed? Knowing that one could do this with ASP (compact and repair from code) made me think it might just be possible in Coldfusion or...
  6. mrsbean

    problem with random

    Glowball, The [text_id] is a number. It is the autonumber field stored in a table which tracks text blocks. I tried using a portion of the time so that I would get a truly random number, but it didn't seem to make any difference. I'll check into the cached issue, but I'm not sure I...
  7. mrsbean

    Compact and Repair Access Database

    I want to find some code that will compact and repair an Access database located on a remote web server. The web server does not have MS Access installed on it. It runs Coldfusion only (not ASP). Does anyone know of a method whereby I can compact and repair Access databases other than taking...
  8. mrsbean

    problem with random

    I want to use a query to return a random set of data. <cfquery name="get_fp" datasource="this_content" MAXROWS=4> SELECT table_text.text_client_id, table_text.text_id, table_text.text_title, table_text.text_content, table_text.text_link, Rnd([text_id]) AS random FROM table_text WHERE...
  9. mrsbean

    delete records based on query with multiple joins

    Here is the code that worked: DELETE specData.* FROM specData WHERE specData.sdID IN (SELECT specData.sdID FROM (specMaster INNER JOIN specColumn ON specMaster.smID = specColumn.colsmID) INNER JOIN specData ON specColumn.columnID = specData.scID WHERE specMaster.smID = 1); I was having...
  10. mrsbean

    delete records based on query with multiple joins

    I know we're getting closer, but I'm not there yet. I took what you gave me, and the Q1 query in the middle was somehow muddled ... I inserted a fresh copy of my Q1 query, and I tried the statement with and without the sdid. The message I get from Access is "Specify the table containing the...
  11. mrsbean

    delete records based on query with multiple joins

    I always have trouble when I need to create a query which will not be stored in Access and call on that query from another query. Today, I need to delete records in a table based on criteria in a table. Here is the query which does not work: Delete specData.sdID from specData INNER...
  12. mrsbean

    chmod script

    I don't have shell access. There is some kind of web access to the files, but I can only apply the permissions one file or one folder at a time, and it's not recursive. I've seen an ftp (Core FTP Professional) which claims to offer recursive settings, but I don't want to spend money if I...
  13. mrsbean

    chmod script

    I am attempting to install SugarCRM on a Linux server. To successfully install, I must set the file permissions for the modules folder and all files/subdirectories to be writable. I attempted to set the directories to 777 and the files to 755 using the following code: <?php system( 'find...
    • mrsbean
    • Thread
    • Replies: 4
    • Forum: PHP
  14. mrsbean

    ftp using command line

    I am attempting to set the permissions for a remote folder (the folder and all subfolders and files) to writable. I have Windows XP. The remote server is Linux. I was able to make an ftp connection using command lines. Is there a command(s) I can use with this method to set permissions? I...
  15. mrsbean

    &lt;cfoutput&gt; tag shows up in link

    Nevermind ... solved my own problem. In the form before this one, it passed a value, form_spec_id. I had used cfform instead of form to create the form and pass the variables. I forgot that in that case, I didn't need to use cfoutput ... could just type value="#form_spec_id#", so when...
  16. mrsbean

    &lt;cfoutput&gt; tag shows up in link

    The following code returns the following link: http://192.168.0.32/phoenixpromotions/users/index.cfm?template=specs_edit_list_1&form_spec_id=<cfoutput>1</cfoutput> I've never seen this before. The <cfoutput> tag shouldn't be showing up in the string. How can I get rid of it? <h3>record...
  17. mrsbean

    alter table - insert new column

    Okay. I figured I couldn't do it the way I wanted. I'll just put it at the end of for now, and sometime when I have late night access to the server, I'll take it down for a few minutes and fix it ... I know it's probably nit picky and doesn't matter, but I want to put the column in order with...
  18. mrsbean

    alter table - insert new column

    I want to insert a new column after a specific column in a table. The database is used online, and I must use a query statement to alter the table. I have the syntax which will add a column to the database, but I want to take it one step further. I want to put the new column in a certain...
  19. mrsbean

    Report First Instance of a record

    You could try something like this: SELECT LEASEID, FIELD1, Min(FIELD2) AS MinField2 FROM yourTable GROUP BY LEASEID, FIELD1 MrsBean
  20. mrsbean

    ListFind not returning a value

    I'm not very good with Coldfusion yet, but it's not for lack of trying. I love coming here for wisdom though[glasses]. <cfif #moveup# EQ "moveup"> <h1>Move up</h1> <h2><cfoutput>#custList#</cfoutput></h2> <h2><cfoutput>#custList2#</cfoutput></h2> <h2><cfoutput>#editList#</cfoutput></h2>...

Part and Inventory Search

Back
Top