Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Exact Contains Search
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...- jarla
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Impossible query sorting?
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... -
Generating referencenumber for bank
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... -
Generating referencenumber for bank
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... -
Generating referencenumber for bank
...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... -
cfloop list problem
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... -
Name conflict with CFFILE COPY
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... -
Name conflict with CFFILE COPY
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... -
Name conflict with CFFILE COPY
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... -
Controlling the size of cfmail
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... -
Evaluate problem
Can you give me an example how can I use that? And what is the reason why those "-" -signs makes the errors? Thanks! -
Evaluate problem
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... -
Reloading problem
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... -
Reloading problem
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... -
No results from this query!
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"...- jarla
- Post #7
- Forum: Microsoft SQL Server: Programming
-
No results from this query!
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...- jarla
- Post #6
- Forum: Microsoft SQL Server: Programming
-
No results from this query!
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')- jarla
- Post #3
- Forum: Microsoft SQL Server: Programming
-
No results from this query!
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...- jarla
- Thread
- Replies: 6
- Forum: Microsoft SQL Server: Programming
-
Difficult(?) query loop
...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 =... -
File from server to another server
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...
