Recent content by manking

Using mysql 5 what is wrong with this statement? DROP TABLE IF EXISTS messages_ulti; CREATE TABLE messages_ulti( PRIMARY KEY (ID), ID INT(11) AUTO_INCREMENT, fromID VARCHAR(50) DEFAULT '', toID VARCHAR(50) DEFAULT '', Subject VARCHAR(50) DEFAULT "Welcomemessage from...

I am trying to load a file. I get the file to load but the category_id and supplier id load blank entries. Can someone tell me what I am doing wrong in the statement below. LOAD DATA INFILE 'c:/inventory.csv' INTO TABLE pos.items fields terminated by ',' IGNORE 1 LINES...

I have a domain, that supports user settup. One of the feature is the user signes up for an account and the script creates a unique domain. IE.. www.domain.com setup new domain equals New_domain.domain.com. My DNS server will correctly read new domains as it support wildcard in a domain...

r937 answer was correct thanks for the help.

Thank you I have placed this in the querry browser select a.Unique_ID , a.Date_Creation , a.createdBy_UserName , a.replies , a.views , a.lastPost_UserName , a.subject , a.Date_LastPost , a.locked , a.announcement , a.lastPost_UserID ...

Can anyone help me convert this access statement to a mysql statement that works select top 50 a.Unique_ID, a.Date_Creation, a.createdBy_UserName, a.replies, a.views, a.lastPost_UserName, a.subject, a.Date_LastPost, a.locked, a.announcement, a.lastPost_UserID, a.createdBy_UserID, a.movedFrom...

r937 Your are right I pasted the wrong snipett. Thanks Manny

I ask for help in rewriting a code snippet yesterday for MYSQL from Access and Discovered I pasted the wrong snippet here is the right one Could some help in rewriting this for mysql?? select a.Unique_ID, a.Date_Creation, a.createdBy_UserName, a.replies, a.views, a.lastPost_UserName...

<cfquery name="GetForums" datasource="#application.MainDB#"> select a.name as category_name, a.Role_Moderate, b.unique_ID, b.title, b.description, b.Show_Description, b.Last_Post_Date, b.Last_Post_UserName,b.Last_Post_ID, b.category_ID, b.topics, b.posts, b.locked, <cfif...

Sorry if not direct. Does anyone know where I could find boxed older versions with license?

I am looking to purchase an older version of CF. Anything % and up. Putting together a server for a non profit so cost is an issue. Thanks Mannyking@yahoo.com

It seems that some one has gotten in to my system and is using my 2000 server to scan ip addresses. I have run AVG 7 daily and not had any viruses. Seems the program is looking for port 3306 on other ip and it goes through whole banks of addreses. How can I find it? How can I stop It?

A question of concern. I run cold fusion 4.5 sp 2 on a windows 2000 server. I use Mysql for a couple of databases. When I set up the Mysql I put in a user name and password. Then as I created two databases when it assigned those databases the password and username as root and "" as the...

Over a year ago I had hackers break intoa windows 2000 machine. They left two directories on the hard drive that had garbage in them. File name with spaces and other characters. I can't open these to delete. I have to go in and change names of files give new rights ect. Is there a program...

I have a windows 2000 server that has never surfed the web, it is co-located in a local phone company. I administrer it remotely. Today I was cleaning the system files up and a pop up add in an IE window appeared. I have disabled the system messenger that a year ago was sending me lots of...