Search results for query: *

I have a database which I typically securely host on my own servers, but I am in the position of having to install it now on someone else's SQL Server. My preference is to completely hide the schema from prying eyes. I know in older versions of SQL at least you could encrypt all your procs...

I am trying to get a single integer value (primary key/identity val from a table) returned in a function. This function queries a table to find the 1 or more records which match criteria I pass in, and the key value I need returned is the key from the very first record in the recordset as I...

Hey, thanks! That looks like it will efficiently accomplish the parse! Fantastic. How about using JS to put one of the parsed values into another input field? And could I also pass the other field name into the JS code so I could use the same function many times in a dynamically built page...

I don't know any javascript, but I am wondering if anyone has any basic code they can show me to help me accomplish a task on a webpage I would like to create (all I really know is databases)... I have a select list with a key value in the value field (which I must keep there to send to my...

Many thanks to you both for responding, I will get to work this morning!! -Kim

I am programming in CF and have 2 drop down lists on one page which both contain I pull from an every-changing database. Although drop down list 1 is pretty small, drop down list 2 is very large and I would like to limit the contents of this long list based on what the user chooses for drop...

Well, I did find a way around it, but not a great one. After trying multiple ODBC drivers I changed my insert trigger to no longer insert a record into another table with an identity key (it's the second table causing the problem - if you have the second table with fewer rows than the first...

Thanks for your efforts - I will look into Access Projects, that's not something I am familiar with and that may hold the answer. The interface is just a temporary one in any case. Again, I do appreciate your willingness to help, and would still appreciate any insight anyone else may have on...

Thank you for a quick response - I did see those functions in BOL when trying to solve this problem. But it's not me asking programatically anywhere for the identity value - it's something SQL just generates and hands back via ODBC to Access, which then has the wrong key for the row it just...

Desperate for some keen advice here. I have an Access 2000 front end connecting via ODBC to a SQL 2K server, which controls all the logic (I will be transitioning to a new interface, so all logic needs to stay on the server). I am inserting rows on a multi-row form into table A. Table A is a...

Desperate for some keen advice here. I have an Access 2000 front end connecting via ODBC to a SQL 2K server, which controls all the logic (I will be transitioning to a new interface, so all logic needs to stay on the server). I am inserting rows on a multi-row form into table A. Table A is a...

Desperate for some keen advice here. I am inserting rows on a multi-row form into table A. Table A is a SQL table which then either inserts a row into Table B or updates an existing row in Table B. An insert/update trigger on Table A manages this process. Unfortunately, when the trigger must...

I'm trying in Access 2000 to create a SQL passthrough query and then use that new passthrough query as a form's recordsource in a single function. This worked in Access 97 but the same code won't in 2000 (WAH!!) - it's like the query isn't getting fully created in time to be used as a...