Recent content by CFB

Thank you sista! That's exactly what I needed to know. Just one other question. Can I use IF statements and other PL SQL language in triggers or would I need to move that sort of stuff into a stored procedure? For instance, if I had some criteria in there to give a discount for purchases...

This is my first time creating a trigger, so please bear with me. I've looked through SQL Server Books Online, Google groups, and these forums, but it's still not clicking. Here's what I'm trying to do. I've got a table which I'd like to create a trigger for. When a row gets inserted, I...

I'm just learning (and getting used to) the .NET framework. I've done some searching around (including these forums) and from what I understand, the use/creation of COM objects has been done away with/changed the introduction of .NET. I can't seem to nail down the specific answer to my question...

Hmm...after reading a few other threads (which I should have done in the first place), I'm thinking that a data warehouse isn't what I'm actually looking for. I'll be updating/inserting the data directly, so I don't think I want to use the data warehouse structure to store the fulltext I'm...

Thanks Kishore. Do you think this is faster than parsing the fulltext I'm storing for each word and indexing each word with a reference to the document it came from? I need to limit who can view/edit/update these fulltext documents based on certain privledges, so I have to use a database at...

Anyone compared Oracle's Full-Text capabilities to SQL Server's? Just curious which database is the best one to use for storage and retrieval of Full-Text.

I'm planning on storing/indexing millions of text documents and allowing them to be keyword searched and retrieved via a web page. I'm trying to figure out the best way to handle this. I know it's a broad question, but does anyone have any suggestions regarding the best way to do this? I'm...

I'm new to the world of ASP. If I were to create a user interface for people using ASP.net and I registered certain ActiveX controls on the webserver I'm using, can I instantiate those controls in the ASP interface? Or, does the user need the ActiveX controls to exist on their local...

Hi. I'm creating a navigation bar with popup submenus for my website using jscript. I want to create the menus dynamically based on results from a database. I know how to pull the result list back with vbscript and know how to create the popup menus with jscript, but I don't know how to make...

Does anyone know how to connect, insert, etc. into a database that is out on the web? I've got an Access database out there that I'd like to have my local VFP client access and update. Does anyone know if this possible? Thanks.

I could change the main menu when the form is active, but the end users wanted a menu directly in the form. They thought this was less confusing since there are already a number of menus in the main menu. Yes, it's a modal form. I definitely can't use a top-level form in this project. Oh...

Right, I'm trying to avoid using the top-level form. I'm looking for other alternatives, if there are any. Thanks again.

What I'd like to do is put a menu in a form that's not top-level. Unless the form is top-level, I don't think this can be achieved through standard VFP commands. Has anyone out there used some sort of workaround or ActiveX control to get a menu into a form? I've tried using the MS ActiveX...

All very intersting ideas, especially passing the binary string. Now I'm new to ASP, JScript, and Web type dev in general (5 days to be exact), so bear with me. I've created a tree using <DIV> tags and each <DIV> tag has an ID. I build these tags dynamically based on query results in the...

Let me see if I can explain what I'm doing. I've got a header.asp for my banner, a navbar.asp for my navigation bar, and a template.asp which I created as a base for all my pages. The template.asp creates a large table on the page with the top row containing <!-- #include...