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...
Unfortunately not. When I asked about other countries reference numbers from my bank, they said that this kind of formula is in use only in Finland. But it would be good to know also about other countries same kind of numbers.
I forgot to tell that that reference number in Finland must be at...
webmigit: Your code worked great!! It´s just what I was looking for! Thank you very much!
I had a Javascript -code earlier what I was using when I was writing invoices to customers manually. But now I wanted to have a system that generates that reference number to customer immediately when the...
...this:
Original number=1234
Those numbers must be multiply with the formula "7,3,1" from right to left. So in this case we must do the multiply 7*4, 3*3, 1*2, 7*1. We get numbers 28,9,2,7. Then we take the SUM 28+9+2+7 and we get number 46. Then we take the nearest FULL TEN upward, which is...
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...
Thanks for all instructions! I decided to name all images that come by email, again with dynamically generated filename like this:
<cfset newname="#timeformat('#Now()#', "HHmmss")##randnumber#_#attachmentsent#">
Then the code use that #newname# to copy the file to customer´s...
Thanks Ecobb, but in this situation it´s not usable because all attachments go first to same "attachment" -folder. After that the script use the CFFILE ACTION="COPY" to copy attachments from attachmentfolder to customer´s own imagefolder. "COPY" -action don´t have...
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="size#asset_name#">
blaa...blaa...
Then little database check and we found...
Thanks for help!
Actually only what I need is the number of pictures that are on the lightbox. For example "2 images". I think it´s enough if I can make a JavaScript which receives that #lightbox.recordcount# -value when the page first load and then when user clicks the "Add to...
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 "lightbox" for ordering. Site is made without frames so when user clicks the "Add to lightbox" -button below the picture...
Hi again!
Now it works! I changed the "nvarchar" to "varchar" and after that the "CONTAINS" -search worked normally... But I really didn´t know that "nvarchar" don´t work as good with "CONTAINS" -search than "varchar"...
Aarrrgh!
Still no results. I just tested some different queries. This works (but of course it´s DAMN slow):
SELECT ID, asset_name, folder_name from picturedatabase
WHERE categories like '%cat%'
(that gives 15026 records)
But this don´t work:
SELECT ID, asset_name, folder_name from...
No. Like I wrote, even this kind of search don´t find any records:
SELECT ID, asset_name, folder_name FROM picturedatabase WHERE Contains(categories, 'cat')
Hi!
I´ve just added "full text search" to our SQL Server 2000 -system. But I don´t know what is wrong with it because it don´t find any records with "Contains" -value. Here is one example query:
SELECT ID, asset_name, folder_name FROM picturedatabase WHERE...
...delimiters="," index="index1">
<cfquery datasource="#mydsn#" name="translate">
SELECT * from translate
WHERE uk = '#index1#'
OR fin = '#index1#'
</cfquery>
<cfoutput query="translate">
<cfset uk = "#uk#">
<cfset fin =...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.