Search results for query: *

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

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

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

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

I have a database that has is something.mdb it is called for in a program. When I try to open it with Access2000 it say the there is a problem with the header. When the program opens the database it copies it to a temp file or something. Is there a way to view this database?

I run 4.5.1 SP2 all of a sudden I can't add CFX_ tags I can change the properties on the old ones (not the name) I also can't change the password or user name in a Datasource. It just started acting up. I reloaded SP 2 no luck. Maybe I accidently lock it out in some way checked a box...

I am using MYSQL with cold fusion 4.5. I put in the following query. select * where messageid > 5 order by messageid One of the columns is messages, it is a text (longtext) colunm. The message column returned is garbled garbage. In my MYSQL admin program I can see the text yet it...

I am using MYSQL with cold fusion 4.5. I put in the following query. select * where messageid > 5 order by messageid One of the columns is messages, it is a text (longtext) colunm. The message column returned is garbled garbage. In my MYSQL admin program I can see the text yet it...

I had the nimda virus. Cleaned the system reloaded win2000 files yet in the c:/ directory admin.dll and httpodbc.dll still there. I have attemped to remove these files but system sayes files are locked may be in use. I have looked none of the &quot;prgrams&quot; that use these dll's are...

Any Ideas whats wrong with this? <CFQUERY name=&quot;gLis&quot; datasource=&quot;#DSName#&quot;> SELECT DISTINCT Types.ID, Types.Type, (Select Count(*) From Listings Where TypeID = types.ID AND Listings.Approved = 1) AS TotalListings FROM Types INNER JOIN Listings ON Types.ID =...

m converting from access to mysql this will not work can someone tell me why? SELECT DISTINCTROW ads.ad_id, ads.name, ads.path, ads.filename, ads.href, ads.active, ads.password, category.category_name, sum(performance.loads) as totalloads, sum(performance.clickthru) as totalclicks FROM...