RE: first web db with coldfusion5

2001-12-02 Thread Spaminator
I've got a book and finally found the info in it to get started. Using the drop down wizard i was easily able to create the search and results pages. Only problem is each field is required for searching, if any fields are blank im getting errors. How can i modify the code so these fields are no

RE: first web db with coldfusion5

2001-12-02 Thread Joseph DeVore
It looks like you need to add some logic to dynamically build your SQL statements Basically, check if a field exists; if it exists then add that field to your sql statement This code might help you get the idea: select departments.department.name, employees.firstname from departments, empl

RE: Where to find a complete U.S. Zipcode listing?

2001-12-02 Thread Chris Wigginton
One resource I've found for zip codes is; CD Light, LLC d.b.a ZipInfo.com(TM) 8861 Silverstone Way Sandy, UT 84093-1679 www.zipinfo.com They provide the information both in Access and Comma delimited text files. The database provides city, state, zip, area code, FIPS, county, TimeZone, and a

Re: Credit Card Encryption

2001-12-02 Thread Kay Smoljak
Hi all, We haven't been able to get CFX_PWCARDCRYPT to exchange keys with other RSA-based systems, because we can't find any decent information! If ANYONE knows ANYTHING about what is going on with ASCII armouring from a technical viewpoint, please please please share! Kay. "Megan Cytron" <[EMA