|
|
Browse by Tags
- 2005
- 2007
- access
- after
- another
- array
- asp
- auto
- blob
- bulk
- cannot
- characters
- clob
- column
- comma
- commit
- crystal
- cursor
- data
- database
- date
- datetime
- db2
- disk
- document
- drive
- duplicate
- error
- excel
- exec
- exists
- field
- file
- form
- Formula
- from
- header
- how
- html
- id
- identity
- ignore
- image
- interbase
- Java
- javascript
- jdbc
- key
- line
- linked
- list
- long
- loop
- macro
- ms
- multiple
- mysql
- null
- number
- ODBC
- one
- only
- oracle
- page
- php
- picture
- powerpoint
- procedure
- query
- quote
- record
- records
- report
- row
- rows
- select
- server
- set
- slow
- sql
- ssis
- statement
- stored
- sybase
- symbol
- syntax
- table
- tables
- text
- time
- timestamp
- trigger
- update
- using
- value
- values
- vba
- word
- xml
-
SQL Insert using both select statements and parameters
Hi all, I suspect the following sproc could be cleaned up a lot but I just don't see it right now. My main area I wish to clean up is in the various select statements as each of them uses the same From... inner join... Where clauses. thx in advance. Code Snippet: 1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11... -
Cannot insert the value NULL into column 'ID'
Hello Experts, well it seems that i always have errors with SQL Server tabels. ............ Microsoft OLE DB Provider for SQL Server error '80040e2f' Cannot insert the value NULL into column 'ID', table 'database.dbo.UserLayouts'; column does not allow nulls. INSERT fails. /custom... -
How do I insert a Windows Media Player Component into a webpage using Frontpage 2003?
I've done this before, but it was a while ago and I used Frontpage 2002. I'm using Windows Media Encoder 9.0 to create live video, and I'd like to push it to my website so I can share the output. If I remember correctly, it was a component that was inserted in Frontpage 2002, but I can't... -
How can I insert video on my html file?
How can I insert video on my html file? -
How to escape single quotes in a MySQL INSERT?
I have this in my code $sql = "INSERT INTO `contractProducts` (`clientId`,`productId`,`productStatus`,`productBTW`,`productPaymentperiod`,`productRef`,`productDescription`,`productPrice`,`productDay`,`productMonth`) VALUES ('".$session{form}{clientId}."', '".$session{form... -
How to insert a Custom HTML tag with FCKEditor
Hi there. Can someone point me in the right direction on how to create a new custom button that inserts a piece a code at the cursor location. I basically want to add a or [more] tag to the source code when the button is clicked. I plan to use this to break the content into two sections if used. -
Inserting NULL Value to MSSQL DATE/TIME Field
Hello, Ok this one should be an easy one. I'm running an insert query and one of the fields is date/time. When I DO NOT send a value to it, I want to insert is as , but instead, it's going in as "1/1/1900". How should I do my query where I can send a NULL Value? Thanks, Anthony -
inserting date/time in to oracle table
Hi all, I am trying insert a record in to oracle table from cold fusion mx.One of the fields is a date/time field.It gives me an error.Below is the code.Please help. YY HH:MM:ss")> Insert into table1(name,ssn,datesubmitted,email) values('xxx','xxx-xxx-xxxx', TO_DATE('#submitdate#'... -
multiple insert using textbox array
hi i have here a form which a result query from database. i would like to execute a script which insert to another table, those data with a check can only be inserted. my problem is that when i check the first 2, skip two data, and check the last data, i get the first 3 data. still the same when i check... -
Insert a check box in Excel 2007
How do I insert a check box in Excel 2007?