Hi,
I have a form set up which collects details and then when submitted it
creates a new record in a table called rbh_vacancies
Most of the time it adds the records perfectly, but there seems to be a very
low number of characters it will accept in each field-
The following code updates the database-
myRS.Open "rbh_vacancies" , myConn, adOpenKeyset, adOpenStatic
myRS.AddNew
myRS("location_ type") = Request.Form("l ocation_type")
myRS("job_type" ) = Request.Form("j ob_type")
myRS("descripti on") = Request.Form("d escription")
myRS("salary") = Request.Form("s alary")
myRS("location" ) = Request.Form("l ocation")
myRS.Update
myRS.Close
Set myRS = Nothing
"descriptio n" is a text area field, and will only be accepted if the field
is no more than 17 characters long, I have tried setting the database to be
text(255), varchar(255), medium text, long text, even tried BLOB. But I
cannot get it to accept more than 17 characters!
I can put more than 17 in if I update the record through a mySQL front end
tool, but not via the browser, does anyone have any ideas!? Could it be
something to do with the way I am creating the record set? - "myRS.Open
"rbh_vacancies" , myConn, adOpenKeyset, adOpenStatic" ??
I am also having similar problems with the other fields, but I guess if I
can sort out the description field, I can sort out the others.
Thanks
Andrew
2  1835 
I'm not sure I explained that particularly well!
Basically - If my "descriptio n" field is 17 characters long, e.g.
123456789012345 67 , it will update the database with the new record.
If I add an extra character to the description - 123456789012345 678 , I get
the following error message-
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.
/admin/dbaseadd.asp, line 15
~~~~~~~~
line 15 of the code is this-
myRS("descripti on") = Request.Form("d escription")
Hope that makes more sense!
Thanks
Andrew
In case anyone ha a similar problem-
I've sorted it, thanks to the mySQL bugs documentation. There was an article
in their saying to add the following to the connection string-
; Option=3
Don't know why, but it works now!
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Matt Young |
last post by:
I've been tasked with integrating an older management system based on
DBF files with my snappy new ASP application to provide users of the
ASP application with real-time data from the management system.
I figure with DBF files, I should use either the DBase drivers or the
FoxPro drivers to connect to the database.
The integration has gone quite smoothly until yesterday. This means
that my connection strings work well based on the...
|
by: Heather Fraser |
last post by:
Dear Sirs,
Given the following table
CREATE TABLE specifications (
objectId int not null default 0,
paramValue varchar(255) not null default '',
INDEX(objectId)
)
|
by: Steven Blair |
last post by:
Whenever I attempt to return more than 255 characters from my MySQl 4.0
Database all I get from the field is 255 characters. The field in the Db
is text and has more than 255 characters.
I am using ODBC.net.
I return my data using the following:
m_DataAdapter = new OdbcDataAdapter(SqlString,GetConnectionString() );
|
by: zek2005 |
last post by:
Hi!
I have a MySQL DB with a text field that includes both text and HTML
tags. When I invoke that field in a page, I only see the text (not the
HTML tags, of course). I only want to chow the first 50 characters of
that field, but If use the substr function the result shows my the
HTML tags, because the HTML tags could be in the middle of the substr
limit, I mean:
$text=This is a <B>test</Bthat I want to show
|
by: bitshift |
last post by:
Im pulling a string out of a text field in sql and into a byte array in my
C# code. Help frefresh my memory here, a single asci character is 1 byte
correct ? So why is a string that is 37 characters long, result in a byte
array that is 2224 elements in length ?
| | |
by: Dean |
last post by:
Hi, I have a table with non-unique identifiers. I need to take all
the values with the same ID's and combine them into one field with a
semicolon as a seperator. These values may exceed 255 characters. I
then need to count the values in the cell and see if it adds up to 240
or more and then shorten that field by cutting off the excess and
adding only "...and other". So, to recap, I need to summarise values
based on the ID field, count...
|
by: Vbbeginner07 |
last post by:
Hi all
Wonder if anyone can help me out to solve this:
please find the code of textbox that accepts only characters and
one textbox that accepts only numbers:
(vb)
textbox for accepting characters:
If txtname.Text = "" Then
MsgBox "enter the name", vbOKOnly, "PAYROLL"
|
by: Steve |
last post by:
Hi guys,
I am working on a Team Process Template for TFS 2008. I have created
my own work item type, which has (amongst other controls) a HTML
control to hold process guidance text:
<FIELD name="Purpose" refname="Microsoft.VSTS.CMMI.Purpose"
type="HTML">
<HELPTEXT>The purpose of the review</HELPTEXT>
<REQUIRED/>
|
by: nidaar |
last post by:
From a security point of view, is accepting wildcards like "%" in
input parameters of stored procedures against any best practices?
As an example, if a user defined function uses "Productname LIKE
@ProductName" in WHERE clause of a select statement, and a stored
procedure uses the user defined function while passing @ProductName
input parameter to the user defined function, is there any security
risks? Is there a better way to construct...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
