Search results for query: *

Hello, professionals ;) We have Sql Server 2000 in our server and it have over 300.000 rows with comma-delimited list of keywords. We use contains -search because LIKE -search is too slow. Database handles picture information. But now we have big problem. This search: SELECT ID FROM...

Hi! Is it possible to do this kind of query sorting, it sounds very difficult to me but I´m not sure about you professionals :) We have picture database with info about 210.000 different pictures. We have many different image producers and we try to serve pictures to customers so that every...

Hi! This could be hard to do, but I trust you professionals :) I need to make so called referencenumber from deliverynumber to use for bank -payment. In Finland the formula to generate the referencenumber is like this: Original number=1234 Those numbers must be multiply with the formula "7,3,1"...

Hi! Again stuck with cfloop. Do you have any suggestions to this, I´ve tried almost everything I can... :( I have a cd-database which have all information about every cd in our cd-shop. There is a datafield "Tracklist". With help of "Valuelist" it´s easy to create nice list...

HI! Once again little problem :( I have a gallery-page and customers can send their photos to the gallery also via normal email. Coldfusion use CFX_IMAP4 -tag to check specified mailbox every five minutes and it works good. BUT: Every customer have, of course, their own folder for pictures. No...

Hi! Is there any way to control how big attachments user send via our cfmail -based system? We have picturebank with download and email -functions and our customers can add group of pictures to one zip -file and then send it via email to somebody. Or download the packet to their harddrive...

I have problem again. Here is little explanation, I hope your understand. First page have drop-down box that customer use to choose the right size for picture order. It have values with this begin: <select name=&quot;size#asset_name#&quot;> blaa...blaa... Then little database check and we found...

Hi! Once again a difficult(?) problem. I hope that you professionals can help me. Our company have picture searching site with option to add pictures to &quot;lightbox&quot; for ordering. Site is made without frames so when user clicks the &quot;Add to lightbox&quot; -button below the picture...

Hi! I´ve just added &quot;full text search&quot; to our SQL Server 2000 -system. But I don´t know what is wrong with it because it don´t find any records with &quot;Contains&quot; -value. Here is one example query: SELECT ID, asset_name, folder_name FROM picturedatabase WHERE...

Hi! I can´t make this query work. First little story about what this query should do: I have picture searching interface on my company´s website. Some keywords are in english, some are in our language which is finnish. So I made database &quot;translate&quot; which have most of typical search...

Hi (again) What is the best way to send file(s) from one server to another server? Example situation: Customer have pictures in his picturefolder in our server and customer have own web-interface to search pictures and send more to customer´s archive. I´m programming a way that that customer...

Hi! Is there an easy way to check what tablefields Access -table have? We have lot of customer -databases with different tables and I need to check what kind of fields database table have. With that information it´s easier to update the table using one &quot;temp-table&quot; and ColdFusion. Or...

Hi! Is there any way to configure Dr.Watson (or some other program) to start crashed program again after it was closed by Dr.Watson? That would be great option. We use picture publishing program to publish pictures to the net and that program sometimes crash. It´s very fast operation to start it...

HI! Is there any way to remove unwanted text from textline. The program I use generates this kind of line: &quot;/scripts/wrap.exe/NPS-10025.jpg?directArg=idieigspvgujueupspvbipjhij,NPS-10025.jpg&quot; All what I need is NPS-10025.jpg. Of course that name is different if the customer choose some...

A new problem again. I have a page where my customer can download pictures with his (or her) username. I´ve wrote a cfm -page which handles database connection. It writes down username, date and the picturename(s). If the user downloads more than one picture, how can I add every of them on...

Hi again! I need some help with this simple problem: I have search form with three textboxs. When the user put words to those boxes and push the submit -button, one cfm -page handles database connection which put those words to database and then launch the searchprogram. It works well with one...

I have very strange problem: One folder on my server contains one *.cfm -page. But when I try to access that page with my browser, I get &quot;Http...Object not found&quot; -error. When I re-name the file so that it ends with *.htm, it works fine. Strange thing is that when I move that *.cfm...

HI! I have made a page which uses Canto´s Web Publisher for searching images with keywords from our server. The other software is ColdFusion, which handles for example user informations. So: I must find a way how to track what keywords our customers use when they search pictures. I have made...