Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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