/    Sign up×
Community /Pin to ProfileBookmark

Please Help Me – Problem With Table Name in MSSQL Server 2000

Copy linkTweet thisAlerts:
Apr 26.2007

Hi Guys,
I use PHP 4.3.11, and succesfully connected to MS SQL Server 2000. The problem is, the table name is [B][COLOR=”Red”]PT DATASCRIP$Service Item Line[/COLOR][/B] of course PHP recognize the table name as a variable because the [B]$[/B], or worst, describe it as an error.

Do you have any idea how to fix this, because 100% impossible to change the table name, because it will break down more than 5 Application, and if i have to copy to another table, the data is to large.

Can PHP read [B][COLOR=”Red”]PT DATASCRIP$Service Item Line[/COLOR][/B] as a table name ?

Please Help Me ?

Thank You and I Really appreciate your answer

to post a comment
PHP

5 Comments(s) ↴

Copy linkTweet thisAlerts:
@NogDogApr 26.2007 — Either put the name in single quotes so that there is no variable interpolation, or if you must use double quotes then escape the $ with a back-slash: $
Copy linkTweet thisAlerts:
@baltazhor200401authorApr 26.2007 — I already try but still error. the space within the table name make it still error ... any idea ?
Copy linkTweet thisAlerts:
@NogDogApr 26.2007 — I think you can use square brackets to "quote" column names in MSSQL, e.g.: [b][column name][/b].
Copy linkTweet thisAlerts:
@s_b37Apr 26.2007 — if nogdog's doesn't work:

can you urlencode ie: " " becomes %20

just a suggestion, prob won't work
Copy linkTweet thisAlerts:
@baltazhor200401authorApr 27.2007 — Thank's for the reply, especially NogDog, i use [B][][/B] and it's work perfectly
×

Success!

Help @baltazhor200401 spread the word by sharing this article on Twitter...

Tweet This
Sign in
Forgot password?
Sign in with TwitchSign in with GithubCreate Account
about: ({
version: 0.1.9 — BETA 6.17,
whats_new: community page,
up_next: more Davinci•003 tasks,
coming_soon: events calendar,
social: @webDeveloperHQ
});

legal: ({
terms: of use,
privacy: policy
});
changelog: (
version: 0.1.9,
notes: added community page

version: 0.1.8,
notes: added Davinci•003

version: 0.1.7,
notes: upvote answers to bounties

version: 0.1.6,
notes: article editor refresh
)...
recent_tips: (
tipper: @nearjob,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,

tipper: @meenaratha,
tipped: article
amount: 1000 SATS,
)...