>
> I added your code as:
> <CFQuery datasource="test" name="#trialname#">
> Create table #trialname#
> (id INTEGER,
> CONSTRAINT #trialname#_pkey PRIMARY KEY (id),
> Orderdate Char (50) not null,
> Institution Char (50) not null,
> Customer Char (50) not null,
> address Char (50) not null,
> city Char (10) not null,
> state Char (10) not null,
> zip Char (5) not null,
> phone Char (8) not null,
> login Char (10) not null,
> email1 Char (50) not null)
> </CFQUERY>
>
> One final problem. I get an error "ODBC Error Code = 23000 (Integrity constraint violation)<P><P> [Microsoft][ODBC Microsoft Access Driver] Index or primary key cannot contain a Null value."
>
> I get this when I try to insert my first record.
>
> My code:
> <CFQUERY name="get" datasource="test">
> INSERT INTO #trialname# (
> Orderdate,
> Institution)
> VALUES ('#DateFormat(Now())#',
> '#FORM.Institution#'')
> </CFQUERY>
You need to insert a value for your primary key field.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
