Search results for query: *

Cool! I'm glad it works. I know that it just reads the user's system time so I shouldn't need to worry about DST, but I just wanted to make sure it was correct. So how do I have it convert all the values that come from the db to the user's time? I know I can pass CF values into it, but I'm...

I want to take a db date/time value in GMT and convert it to the local user's date/time. We have a lot of site users all over the world and I thought it would be helpful for them if it were easier to know when our online events were going to happen by seeing it in their own date/time. I've...

I'm doing a similar type of search as in tleish's post where the cfsearch gets the records based on the search term and then I do a secondary query to narrow the records down even further. I copied tleish's code and most if it works fine but I've got a problem. For some reason the second...

I am creating a search page that allows users to be able to enter a search term and also limit the categories they want to search in. Each piece of editorial can be marked with up to 40 different topic areas (categories). So I did a cfsearch to match the search term and then a query after that...

To pass values to a Crystal Report, I did use ASP, but I guess you could probably use a regular HTML form or ColdFusion or whatever. Just name the form fields as prompt0, prompt1, prompt2, etc. depending on what order it asks for them in the report. So if you run your report in CR and find...

YES! *does the joyous arm motion* We figured it out! Here's our solution. Moved the subreport information to the main details section (since we no longer needed it to be a subreport). Right click on the appropriate field (mine is company name) and choose Format Field option. Select the...

ok, I'm slightly cheered by the fact that you, a very advanced user, also don't understand their description for hyperlinking to a new report. I guess I'll keep searching the Internet for an answer and tell you if I find something. Thanks for all your help, Jessica Hill

Ok, now you've got me questioning our method. Does the following description make sense? The main page returns the full search results, which is many various sales leads. If they contact a lead and decide that they want to be a client, then they want to put this contact into ACT. We didn't...

Oh my gosh, don't confuse me! :-) Your example is how my original all-ASP pages were working, with If..Then statements. We're working with only one table and it's suppose to be properly indexed, aside from the current space issues. So in theory, when we're done, it'll be done properly...

Oh wait, I found it! Hopefully this is decent performance-wise, but I'm using "startswith". If it's not so good to use with about 2 million records, the please tell me what else to do. Rock on. I might actually finish this project, that once seemed overwhelming. Jessica Hill

Thank you Brian. So far I've got it working in CR, getting it passed from the ASP page is a bit trickier. We've got the actual details worked out, but it't not always running the report, which is something on our end, some sort of server problem or something. Our tiny little bug is that I...

Thank you Brian, I really appreciate the help you're giving me, plus the quick responses. Unfortunately I don't want a compounding query. The intention is that the user is going to pick only 1 of the location parameters (state, area code, zip code) so some sort of OR function is what I need...

Hi there. I've done the first step and part of the second step. Whenever I add a second parameter(area or zip code) it doesn't use that for the query. Just no results even though I'm searching for something that I'm positive is in the db. I wrote this in the Record Selection Formula...

Ok, but how do I get my "If...Then" statements in there? I know the query won't run if I don't have them in there, it has to be structured like that. We've tried everything and it really won't work written any other way. Not unless you can have CR recognize what items weren't...

Hmmm...sure! Sounds like a decent way to accomplish it. I've already created the page in ASP but it times out (2.4 million records) and CR seems to be able to handle all the records and we can export the data to ACT!. The only way I've done CR stuff is to create the report and then do the...

Ok, from what I understand I think should be able to use vbscript to create a SQL query to get my information from my db. But I can't find anything that tells me how or where to write this code. It would start out with the user selecting the particular parameter values they want to search on...