|
|
Browse by Tags
- 2000
- 2005
- access
- ado
- aim
- array
- call
- case
- check
- control
- convert
- copy
- could
- create
- crystal
- csv
- cursor
- data
- database
- dataset
- db2
- debug
- display
- dts
- dynamic
- excel
- execute
- exists
- extended
- file
- find
- firebird
- from
- function
- how
- import
- insert
- interbase
- list
- loop
- messages
- ms
- mssql
- multiple
- mysql
- name
- nested
- number
- oracle
- outlook
- output
- parameter
- parameters
- pass
- passing
- password
- passwords
- perl
- php
- postgresql
- proc
- procedure
- procedures
- query
- records
- recordset
- remove
- report
- reporting
- reports
- result
- return
- run
- schema
- select
- server
- services
- sql
- sqlyog
- ssis
- statement
- sybase
- syntax
- table
- temp
- temporary
- toad
- transaction
- trigger
- update
- user
- using
- value
- variable
- vb6
- vba
- vbscript
- view
- where
- XML
-
call a stored procedure in javascript based to check form data
Hi all, First off, I am not sure if this is possible, but would like to know if I can call a procedure in javascript. I am using a coldfusion and html. Javascript to validate the form when the user clicks submit. Basically, what I have is a form with several fields. One of the fields is a userid. I need... -
asp classic / stored procedure execute & return value
I need to be able to use asp (classic) to execute a stored procedure that has 1 parameter and returns it's information into a recordset. I have tried quite a few code examples from the web and nothing has worked so far :( the Stored Procdure is: spMyCalc It takes parameter: @intUnitID It returns... -
Where is the Internet Explorer certifiate stored in the registry?
The boot sector of my client's hard drive crashed and will not boot. I installed the crashed hard drive in another PC and was able to transfer his important data to the new PC. The only thing I could not pull off the old drive was the certificate for Internet Explorer because normally the certificate... -
Executing a stored procedure with in out parameters
Hi, I am just trying to execute stored procedures that are already built, and i get error messages when i try to execute. I have several IN parameters that i assign, but my IN OUT parameters i don't have the values for, or i don't think they are relevant. So i go in sqlplus and type exec stored_proc_name... -
Difference between Stored-Procedure and Function
Hi folks, I need differences between stored-procedure and functions with an example. What are the differences between stored-procedure and triggers? what is a view? Thanks, Pampa -
Firefox bookmarks - where stored?
I am moving to a new laptop and cannot find where Firefox bookmarks are stored. Have searched through all folders and only found bookmarks.html - cannot find what it's reading to display. Have moved all bookmarks.html to new laptop to corresponding folder - no luck. -
Using case statement in Stored procedure
I have the following stored procedure that runs 2 sql statements, basically the statement are the same except for an additional "AND" clause when @intReg > 0. Firstly this does not work, I get a message to say incorrect syntact at ">" Second, I don't think this is very elegant... -
Writing an insert/update stored procedure
I have a table called Product with the following fields product_id, name, description, company, country where product_id is an automatically generated ID. I have a stored proc to insert new data into this table (see attached code snippet). I have two questions 1) Is it ok to use the same names for the... -
.NET CLR Stored Procedure Active Directory query
Cand you Create a .NET CLR Stored Procedure that quieries Active Directory without a linked Server solution? -
MySQL 5 Stored Procedures --> update temporary table via cursor
Hi there- I have two cursors in my procedure, one which selects a set of data and inserts it into a temporary table (the_table) and one which then updates a column in that table. When I attempt to CALL it written in one procedure, it gives me the error: ERROR 1109 (42S02): Unknown table 'the_table'...