[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Sybase problem with spaces in cart names
****** message to minivend-users from Stefan Hornburg <racke@linuxia.de> ******
"Robert Schaller" <schaller@headline.de> writes:
> ****** message to minivend-users from "Robert Schaller" <schaller@headline.de> ******
>
> I'm having a problem with Minivend 3.12 running with the Sybase ASE
> 11.0.3.3 on red-hat 5.2. The problem is, if I save a cart under a name
> containing spaces ( for example: just another test ), I'm getting three
> carts back when I retrieve it:
>
> 1. just
> 2. another
> 3. test
>
> and I can't delete them. It seems the spaces are not being handled
> properly? The carts field is of type text in userdb.
>
> Can anyone help me? thanks!!
Character usage restrictions
To review, database identifiers, field names, and product codes (database
keys) are restricted in the characters they may use. A
short table showing restrictions:
Legal characters
---------------------
Database identifiers A-Z a-z 0-9 _
Field names A-Z a-z 0-9 _ # - . /
Database keys (product code/SKU) A-Z a-z 0-9 _ # - . /
Database values Any (subject to field/record delimiter)
You probably should restrict the field names to the same set of characters
as database identifiers -- this will prevent conflict with
external database programs, noticeably SQL databases which use the period
(.) as a table.field separator.
Ciao
Racke
--
LinuXia - Solutions of Cool Competence - Internetprogramming and more
D-30163 Hannover, Waldstraße 4, 0511-3941290 (http://www.linuxia.de/)
Come to the land of real computing where penguins and their friends
spread the word of Open Source which crushes windows instantly.
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
