Search results for query: *

Okay, got this fixed: The test-server had had the BUILTIN\Administrators user deleted. We added it back in, and voila! it works. mrdenny: I think I read another post of yours somewhere here regarding the BUILTIN\Administrators, and remembered it when I was checking user rights. Thanks for the...

Yes. Rebuilt & repopulated. Twice ;-). We moved the database over via an export. Had initially done it with detach-attach, but when full-text wasn't returning records, decided to try export instead. Cheers, Kris

Hi all, I've moved a database to from our development server to our testing server (both SQL Server 2K, both with full-text search installed & enabled). On the old server, full-text search worked fine. On the new server, with the exact same data, full-text searches return zero records. The...

Hi all, I've moved a database to a new server (both SQL Server 2K, both with full-text search installed & enabled). On the old server, full-text search worked fine. On the new server, with the exact same data, full-text searches return zero records. Any clues? Thanks, Kris

Thanks Shane, That is the solution. Cheers, Kris

Thanks TruthInSatire. This was exactly the issue. Doh! Cheers, Kris

Sorry for the cross-post, but I thought this topic might be outside the norm in the DW forum: I'm finally working in Dreamweaver as my editing environment and am loving it. But I'm no DW expert and need some help. I'm developing a CF application (AppA) that uses components. All is going well...

I'm finally working in Dreamweaver as my editing environment and am loving it. But I'm no DW expert and need some help. I'm developing a CF application (AppA) that uses components. All is going well, except that dreamweaver will not show the components in the component tab. It does show a...

I've been struggling with an instance of SQL Server tools on my PC for a month now. Finally uninstalled and reinstalled this morning and still haven't been able to fix the problem. From Enterprise Manager, anytime I change the structure of a table, attempting to save the table changes results...

I've been struggling with an instance of SQL Server tools on my PC for a month now. Finally uninstalled and reinstalled this morning and still haven't been able to fix the problem. From Enterprise Manager, anytime I change the structure of a table, attempting to save the table changes results...

Hi bombboy, Thanks for the info on variable naming. Definitely worth remembering. In the end, I did not need to evaluate at all. I was able to solve this by abandoning dot notation. Simply using form[UID_C823B934-932A-4A3F-935E-0D5B0345A71B] rather than...

Hi Bomboy, Thanks for the response, but DE() is for Delayed Evaluation, for specific use within Evaluate() and IIf(), where you want to pass a string that should not be evaluated as an expression, such as a string of characters that happen to have hyphens in it. I've also seen it used for...

Hi all, I'm stumped (or tired). I'm looping through form.fieldnames and want to update the database record if the value of the field is not an empty string. However, the fieldnames are set dynamically using the record identifier such as: UID_C823B934-932A-4A3F-935E-0D5B0345A71B such that...

Hi and thanks for the quick response. Yikes! I added the doctype to my files (can't believe I left it out), and everything broke. Looks like I'll be recreating this with a tabled-layout. I'm not ready for prime-time table-less yet. Cheers, Kris

Hi folks, I'm trying to make the big leap to table-less layout, and have been having good success when viewed in the browser. Unfortunately, when I attempt to print everything is all mucked-up. I've been using float:left for positioning DIVs side by side (for instance: first-name and...

Okay, this one was a nice try (the insert from temp table w/ join), but the join still resulted in duplicates. Alas, it may just have to be inefficient. Thanks for the effort. Cheers, Kris

Yes, table2 has multiple eid's. For the purposes of this example, there is a category field which is the differentiator for each set of eid's. I'm basically taking a flat-file and converting it to a related structure. Cheers, Kris

Yes, quite true on the NULL issue. But could you simply add another WHEN clause (and turn some things around)? Such as: select id, title, bitfield, yesno=CASE when bitfield=1 then 'Yes' when bitfield IS NULL then NULL else 'No' end from table1 I haven't tried this, just...

Hi Donutman, Here's something representing what I did that works: --this pulls all the non-text-type data fields insert into table1 (id, field1, field2) select distinct eid, efield1, efield2 from table2 --this pulls the text-type data fields update table1 set...

Hi Donutman, Yup, your solution works. The update statement will work, although it's not particularly efficient (a SET occurs for every row in the source [table2 in my example], even duplicates). But heh, you can't have everything! Cheers, Kris