Member Avatar for dinilkarun

we are able to query successfullu from a Column called "ParentUUD" (without space) using query

"SELECT Name FROM PartVersion WHERE ParentUUID='"+ str(lstUUID[0]) +"'"

we have a column whose name is "Parent UUID" (with space)
We are trying to query the column from PYTHON. we are getting error.I think the error is due to space in the column name.

Please tellus the method to query the MS access DB with column names with spaces.

  • 3 Contributors
  • 2 Replies
  • 339 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by LEwen
Member Avatar for boblarson

Encapsulate the field name in square brackets

[Parent UUID]

and in the future do not use spaces in field or object names as it simplifies things if you don't.

Member Avatar for LEwen

Put [] around name.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.