U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » SQL Insert Statement without a value[SOLVED]

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

SQL Insert Statement without a value[SOLVED] [message #3139]

Mon, 08 May 2006 23:17

Justin is currently offline

Justin
Messages: 57
Registered: March 2006
Location: Orange County California

Member

Hi Guys,

I am trying the following insert command and it is working. However, this command does not work if the fields are empty. Is there a simple way for this to work without having to validate each field and create some type of NULL value?


	sql*Insert(NC_SUPPORT)("name", ~supportform.edtName)("company", ~supportform.edtCompany)
						("email", ~supportform.edtEmail)("status", ~supportform.lstStatus)
						("phone", ~supportform.edtPhone)("country", ~supportform.lstCountry)
						("product", ~supportform.lstProduct)("units", ~supportform.edtUnits);

[Updated on: Tue, 09 May 2006 01:44]

Report message to a moderator

Send a private message to this user

[Message index]

		SQL Insert Statement without a value[SOLVED] By: Justin on Mon, 08 May 2006 23:17
		Re: SQL Insert Statement without a value By: mirek on Mon, 08 May 2006 23:26
		Re: SQL Insert Statement without a value By: Justin on Mon, 08 May 2006 23:42
		Re: SQL Insert Statement without a value By: Justin on Tue, 09 May 2006 01:13
		Re: SQL Insert Statement without a value By: mirek on Tue, 09 May 2006 01:37
		Re: SQL Insert Statement without a value By: Justin on Tue, 09 May 2006 01:41

Previous Topic:	SqlExp and LIMIT
Next Topic:	SQL, U++, and Escape Characters[SOLVED]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sat Jul 05 11:14:17 CEST 2025

Total time taken to generate the page: 0.03577 seconds