...are concatenated in the first place.<BR><BR>Check out split() function in VBScript or split() method on JScript:<BR><BR>http://msdn.microsoft.com/library/en-us/script56/html/vsfctSplit.asp<BR>http://msdn.microsoft.com/library/en-us/script56/html/js56jsmthsplit.asp<BR><BR>Oliver.
ok but what about putting it into a FOR loop. Like I have a certain amount of values in that string that I want to split up and make dynamically created values for each of the split values. any more help I can get? (thanks!)
I have a form that is going into my Access DB and since one of the values usually gets too long for Access to handle (it can only take up to a certain amount of characters) I am splitting it up and putting it into a separate table, with the new split values as their own entries in the new table. I have to use 2 different INSERT statements and it's pretty confusing but right now it's the only way I can do it. The for loop was an idea to get ALL of the values, but like I said, I'm not sure how to do it correctly. If you want to see a working demo go to http://www.rojico.com/view_orders.asp. That is the processed forms and as you can see when you click on an order, the products is being chopped off because it is too long. This is because when it's inserted into the Access file it stop after a certain amount of characters. Right now this value is in one column, but I want to split it into however many items there are, and then insert those into a separate table in my database. THEN I can output THAT information and output all the values without having them be chopped off.
I actually think the length of a memo field may be unlimited...<BR><BR>Check out this article on google...<BR><BR>http://groups.google.com/groups?q=access+length+of+memo+field&hl=en&lr=&ie= UTF-8&oe=UTF-8&selm=3389a10f.2192771%40news.earthlink.net&rnum= 6<BR><BR>Its possible that the string variable you are storing your data in is not big enough to hold all of your data in it (highly unlikely) <BR><BR>Approximately how many characaters are in this string?<BR><BR>-- Whol
If you use an access memo field you should be able to hold 65000 characters (I think).<BR><BR><BR>HOW CAN I DO THIS <BR>this would be awesome if i could but i don't know how? <BR><BR>Thanks so much!