Recent content by mmaddox

Can anyone help with this problem? Page one has a drop down where the user selects a Site. Site is passed to page two where the selection is used in a SQL where clause. That works fine. Page two has click to sort column heading which re-loads the page with Order By info. However, when the...

Thanx philhege, that did it. (lastname+',%20'+firstname) AS URLNAME

I Create a list with this query: SELECT lastname, (lastname+', '+firstname) AS NAME This results in a name correctly formated as Doe, John It displays as a hyperlink: <cfcol header="Name" text="<A HREF=owner.cfm?name=#name#>#name#</a>"> Clicking brings up the owner.cfm page, which gets info...

If you are using Internet Explorer you could check Tools, Options, Advanced, Multimedia and be sure there is a check in the "Show pictures" box

When editing a page in Dreamweaver MX 6.0 the styles (linked to external CSS) are not rendering. Is that normal behavior in Dreamweaver? They do render when viewd thru a browser or when I edit in Front Page. I'm not sure what is normal or if I have something turned off. Thanks for any advise

Thanx linney. The registry edit procedure allowed me to change it to an X instead of the G. This is a work-around, but seems to be ok. I have never seen the FAT partion on the C drive be given a drive letter before.

My computer has started mapping the FAT boot sector as letter drive G. It boots ok, but I need G for something else. Any ideas on how to move it back to not having a drive letter map. I can’t do anything with it in Disk Management. It is a primary Fat partition on Disk0 (same as the C drive)...

I installed XP pro on a couple of computers and assigned them both to a workgroup (not a domain). I also set up the user accounts. Now, when the computers start up the users names are listed on the screen. They click their name and log in. I would prefer the traditional Ctrl Alt Del to get an...

Thank You, that did the trick.

I have a single Server with a single database with multiple tables. I want to split off some of the the tables into a seperate database on the same server. I have been able to do that by various methods - attach, copy, restore and giving the new database a new MDF and LDF name. Then just...

Thank you. The cfif IsDate thing works as a fix. Other info: There is no mask, no default value, and if I add data via a Microsoft Access front-end, the date field stays NULL if no data is input.

I have an insert statement that inserts data from a form into a MS SQL table. One of the fields is a date. If the user leaves the date blank (perfectly acceptable) It inserts as 1/1/1900 rather than Null. To avoid that I am testing for no date input, then if blank it uses an insert statment that...

Ok, thanks for the advice. I guess I will split the table up and go from there. Thanx. I gave you a star for not encouraging me to head down the wrong path.

I have a table which contains “hours worked” for different trades (electrical, plumbing…) there are 14 of them. A single record has a field for each trade. There is also a field for total hours, which is the total of all trade’s hours for that record. I know this could be calculated at runtime –...

You may want to try TOOLS, Database Utilities, Compact & Repair database. Then, open a form in design view, click the "Code" button on the toolbar, then in the Code view click the "Debug" tab and select "Compile" then try makeing the mde again.