Search results for query: *

What is the easiest way to keep a setup of local table in sync with views on a remote server to which I have limited access? Thanks in advance!!!

I've done a little more research and come up with the following process. Before I do this on our live server, could someone confirm it's the right processs... http://www.andrewhopper.com/tech/qmail_migration.html Thanks

I need to migrate current mail and accounts from one Qmail server to another. Do I just need to rsync /var/qmail/conrol and /home/vpopmail and switch the DNS? How do I forward messages that still go to the old server after the new one is online? What else do I need to be aware of? Thanks!

I'm migrating a web app from MSSQL server to Postgres and I've encountered a strange problem I can't seem to get around. I export the data from my Microsoft server to a text file, everything work flawlessly with the exception of the image columns. It seems as though when the data is exporting...

I worked some of the kinks out and got this function to run, however it doesn't insert any data :-(. CREATE OR REPLACE FUNCTION log_page_view(INTEGER,VARCHAR,VARCHAR,VARCHAR,VARCHAR) RETURNS INTEGER AS ' DECLARE local_account_id ALIAS FOR $1; local_cookie_id ALIAS FOR $2...

I'm migrated a webapp from MSSQL to Postgresql and I'm having some problems with the store procedure. This is what I have so far, but it doesn't seem to be working. What I need to do 1.) Get the visitor_id I want to check to see if the current cookie is associated with a visitor_id, if the...

...= t1.last_tm) group by RequestUri,ServerName Average Number of Pages per visit select avg(pages) as avgPages from (select Cookie , count(*) as pages from WEB_Log WHERE AccountID=1 group by Cookie) t1 Average Visit Length select avg(datediff(mi,first_tm,last_tm)) as AvgVisitLength from...

...information: Top Exit Pages This is what I need to do: 1.) group rows by SessionID 2.) order each group of rows by Timestamp DESC 3.) select top 1 * from each group of rows 4.) group the remaining rows by RequestedURL and count the number of rows which contains each RequestedURL Average...

...The query executes without any problems, however neither WHERE clause seems to be executed. All rows from idxmls1 are returned. SELECT idxmls1.* FROM idxmls1 WHERE mod_date_time > (SELECT matchDate FROM OPENROWSET('SQLOLEDB','sql.myhost.com';'uid';'pwd', 'SELECT matchDate FROM...

Problem solved! I as using the wrong syntax for the SUBSTRING function.... I was using SUBSTRING(string,start,end) but I should have been using SUBSTRING(string,start,length). Ooops!

I'm still completely stumped by this problem. It appears that the SUBSTRING function is outputted an error when it tries to access image data after the 8000 character mark? I don't understand why this behavior is happening, and I haven't been able to find any explaination. I can work with the...

Hmm, the sql query string is only 2500 characters or so. It all fits in one local variable. The problem is def in the rowsize limit of SQL. Is there any way to circumvent this though?

After I posted my message I realized I could just concaterate the string like Zathras mentioned. I've done that, but I'm still receiving the same error. It appears as though there's a maximum rowsize of 8000 characters. Here's the response from the server:SELECT SUBSTRING(medium_photo,0,255)...

Thanks for the response!! It's prompts another question- The max size for a VARCHAR dataype is 8000 characters, and local variables cannot be text or ntext, so, how can I accomplish this if there are no variables large enough to hold the sql query?? Thanks in advance

I'm working on a stored procedure that will split up an image into a bunch of different columns so that I can display images using a php script. This is necessary, b/c php will only return 255 characters per field. I've been able to sucessfully generate the sql query, but it isn't executing...

...in the CREATE DATABASE command such as I have done below? I've been getting some errors and haven't determined if this usage is allowed. /* define variables for this script */ DECLARE @DBFilePrefix VARCHAR(255), @DBFileRoot VARCHAR(255), @DBDataFile VARCHAR(255), @DBLogFile...

I have a Windows 2000 server running routing and remote access and server as a NAT router providing internet connectivity to an internal network. When clients connect to the local network using VPN they loose the ability to connect to the internet. The clients are Windows 2000 or Windows XP...

I've setup a zone on my Windows 2000 Server for my domain, but I haven't been able to determine how to setup a catchall, alias, or wildcard dns record. I'd like to direct whatever.domain.com to www.domain.com without explicitly creating a new cname record for whatever.domain.com. Essentially...

I have a table with some property information, another table with some more information about those properties, a table which contains the relationships between media files and properties and a table to contain media. When I use joins to get the information I'm looking for I return more rows...

Thanks for the prompt reponse rudy, however it won't solve my problem. My problem is some properties will not have a picture, but I still need to get the information about the property. Other properties will have may pictures, but the picture may not be specified as the default, in which I...